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.googlegroups.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