creating empty database

Brian DonahueBrian Donahue Posts: 6,590 New member
edited June 9, 2004 10:26AM in SQL Compare Previous Versions
Hi Phillipe,

Thanks for your post. SQL Compare can use a snapshot to create a
database, but the database has to exist already: you'd need to create it in
Enterprise Manager or Query Analyzer. The crucial Create Database command
would be missing from the snapshot because it's really only designed to
compare two databases that already exist.

You may be interested in the upcoming SQL Packager software -- that will
script a database into a snapshot and create an executable file that will
create the entire database -- including/excluding the data if you choose.

Here is a URL with some more information:

http://www.red-gate.com/sql/sql_packager.htm

Regards,

Brian Donahue
Red Gate Technical Support

"Philippe Bergeron" <[email protected]> wrote in message
news:[email protected]
> Hi,
>
> Can I use snapshot to create empty database ?
>
> I tried to update a database X from a snapshot, and it works very well,
but
> I would like to know if the database X doesn't exist, can I just create it
> from the snapshot ?
>
> Thanks.
>
> Philippe Bergeron
> [email protected]
>
>
This discussion has been closed.