tool that create sql script to recreate a database

[Alberto]

I need a tool that creates a script to recreate a db, including tables' data.

Does it exists freeware ?

thanks!

[Simon Hayes]

"Alberto" <il****@libero.it> wrote in message
news:fe**************************@posting.google.c om...

I need a tool that creates a script to recreate a db, including tables' data.
Does it exists freeware ?

thanks!

Backup and restore is usually the easiest way to copy a whole database,
although there are some things to look out for:

http://support.microsoft.com/default...&Product=sql2k

Otherwise, you can generate scripts for the objects from Enterprise Manager
(right-click the database and select All Tasks - Generate SQL Script), or
using SQLDMO. There's no direct way to script the data, but you can use
bcp.exe or DTS to export it to flat files, or use something like this:

http://vyaskn.tripod.com/code.htm#inserts

Simon

[Alberto]

> Backup and restore is usually the easiest way to copy a whole database,

Of course... but we need the script to make some sort of versioning human readble.

bcp.exe or DTS to export it to flat files, or use something like this:

http://vyaskn.tripod.com/code.htm#inserts

That's perfect!!

Thankyou!