Friday, February 24, 2012

Backup MS SQL server database to sql script

I'm searching a tool to make backup of MS SQL SERver 2000 Database to sql
script (with inserts).
Do yoy know any tool to it ?
Enterprise Manager can script the database objects for you (right-click
the database, select All Tasks > Generate SQL Script).
For simple INSERT scripts, try the following:
http://vyaskn.tripod.com/code/generate_inserts.txt
You may want something more sophisticated than the above in which case
you'll want to purchase some software such as:
http://www.red-gate.com/products/index.htm
David Portas
SQL Server MVP
|||... and some other options...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1127400591.364448.197150@.g47g2000cwa.googlegr oups.com...
> Enterprise Manager can script the database objects for you (right-click
> the database, select All Tasks > Generate SQL Script).
> For simple INSERT scripts, try the following:
> http://vyaskn.tripod.com/code/generate_inserts.txt
> You may want something more sophisticated than the above in which case
> you'll want to purchase some software such as:
> http://www.red-gate.com/products/index.htm
> --
> David Portas
> SQL Server MVP
> --
>

No comments:

Post a Comment