creating empty database

Brian Donahue

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" <philberg@conceptformula.com> wrote in message
news:sBh0wSKTEHA.2168@server53...
> 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
> philberg@conceptformula.com
>
>