Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
11-03-2006, 08:22 PM #1
- Join Date
- Aug 2006
- Richmond, CA
- Thanked 16 Times in 15 Posts
mysqldump-like tool for SQL Server 2000
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.