Create a database script.

Forum for users of SQL Compare schema synchronization utility

Create a database script.

Postby prw » Tue Jun 12, 2012 3:08 pm

I'm trying to use SQLCompare to create a script of a current database but don't appear to be able to get it to work to produce the script as one script rather than all the objects as an individual script for each object.

There doesn't appear to be any option to make this possible ?
Posts: 2
Joined: Tue Jun 12, 2012 3:03 pm

Postby james.billings » Thu Jun 14, 2012 6:03 pm

Thanks for your post.

If you're using the "make scripts" option, this is to create a set of scripts that represent a database for further comparisons.

If you compare to a blank database, then it will generate one script to create all the objects; but the database needs to exist to begin with. There's nothing to stop you editing the generated script to include the create database command at the beginning though.

Depending on what you're trying to achieve, you may also want to look at SQL Packager - this can generate an .exe you can run to create a database.
Posts: 1122
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests