View Full Version : mysqldump-like tool for SQL Server 2000

Daniel Israel
11-03-2006, 08:22 PM
Hi everybody,

I'm working on a project where the data is in an SQL Server 2000 database. I don't have access to the machine (it's a web project and the server is an ISP) and therefore I'm limited to what I can do.

I need to move the entire database from one machine to another. However, I would like to make a few changes to some tablenames, data, etc. If I was using mySQL, I would do a mysqldump on the database. This would produce a text file that would contain the SQL statements to recreate the database. I then would make the changes by hand, then send the file to the new database and it would be replicated.

So, I have 2 questions.

1. Is there such a manner to get this file for an SQL Server 2000 database? (that moves tables, views, and stored procedures)

2. Once I have this file, is there a way to feed that file of SQL statements to the new server to generate the database?

Any help is appreciated, thanks.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum