How to copy the databse Schema via a Job

• Jorge Herrera

  SSC Enthusiast

  Points: 166

  More actions

  April 24, 2003 at 7:13 am

  #160094

  I have a production server with a database that the user vendor program allows them to alter the schema (add new colums and tables),

  Note this production server is on a privet virtual lan.

  I need to create a Job that will generate a script to create the full database script for this database, them I will have the Backup group move this file to the QA server in another virtual lan.

  All I need is the new schema in QA server not the data. This will allow me to duplicate the ever changin schema.

  Note: the data base in production is cleared and repopulated by the user every day.

• Jeremy Kemp

  SSCertifiable

  Points: 6754

  More actions

  April 24, 2003 at 7:37 am

  #455184

  Have you looked at Bill Wunder's tool in the the Freeware section?

  Jeremy

• Rajesh Patavardhan

  SSCrazy

  Points: 2801

  More actions

  April 24, 2003 at 9:16 am

  #455224

  One alternative is to use SQLDMO. The Database object in SQLDMO has a GenerateSql Method which generates the scripts for all objects in database.

  You can write a vb program to generate script from dmo and write it to a file and schedule this program via sql*server.

  Hope this helps.