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.