Create a database script.

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Create a database script.

Postby prw » Tue Jun 12, 2012 4: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 ?
prw
 
Posts: 2
Joined: Tue Jun 12, 2012 4:03 pm

Postby james.billings » Thu Jun 14, 2012 7: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.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests