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
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 4: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: 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