Posted by Mork69 on 02/13/07 09:36

On Feb 13, 6:07 am, "farseer" <fars...@optonline.net> wrote:
> Hi,
>
> I need to take data from a SQL Serer 2005 database, and load into a
> remote 2000 database. I've already been able to script and create the
> database objects (MS SQL Server 2005 has a nifty option which allows
> you to scripting for SQL Server 2000 compliance). Now i just need to
> get the data in.
>
> Is there a tool or utility out there that i can use to generate insert
> statements for all the tables in database?
>
> Thanks much for any advice regarding this.

Hi,

Yes, there is and it's called DB Ghost (www.dbghost.com). It has a
Data and Schema Scripter (which does what you need) and a host of
other tools that form a complete change management process for SQL
Server.and can all be called from the command line for full process
automation :)

Kind regards,

Malcolm

[Back to original message]