generate sql script

  • I know you can right mouse click to generate a database sql script, but I have about 175 databases I need to do this on to convert them to unicode.

    How can I do this somewhat easily?

  • You can use PowerShell in combination with the ability to generate scripts to do it for multiple databases. If you search Allen White's blog I know he has a script that will walk through all the objects in a database to generate a single script.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply