Tool to Generate SQL Script?

• htt

  SSCertifiable

  Points: 5242

  More actions

  October 11, 2002 at 9:59 am

  #58383

  Hello,

  I need to generate SQL scripts to create databases and all objects such as tables, views, SPs, users, roles, etc. in the databases. I can use EM but the problem is I have around 100 databases each server and 5 servers to do this. Is there a free or share tool that can accomplish the requirement with just one click for the whole server instead of doing each database?

  Thx.

• Michael S. Armentrout

  Ten Centuries

  Points: 1178

  More actions

  October 11, 2002 at 1:04 pm

  #438393

  This could get you started. It does not script databases/roles, but you could easily alter it.

  http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=486&CategoryNm=Maintenance%20and%20Management%20&CategoryID=1

  Be great!

  Michael

  
  Be great!
  Michael