generate sql script

• Sailor

  SSCertifiable

  Points: 5246

  More actions

  October 19, 2012 at 11:11 am

  #393427

  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?

• Grant Fritchey

  SSC Guru

  Points: 399014

  More actions

  October 19, 2012 at 11:34 am

  #1550990

  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