Moving objects from 1 SQL Server to another

Greetings one and all,

I hope some here can help me.

We are currently running SQL Server 2000 on 2 different servers. The first server was an upgrade from SQL 7 so the data, etc are in a directory named MSSQL7. The second sever is newer and larger (Disk and Memeory) and was a straight install, so the data is in MSSQL.

I am trying to move everything from the old server to the new one. The databases are easy as well as the users. I can not get my DTS packages, DB Maintenance, and SQL Server Agent jobs from the old one to the new one.

Any ideas?? We are running out of room on the old server and need to get this moved over asap.

I look forward to hearing from someone.

RayFor the SQL Server Agent jobs (and DB Maintenance as well, as they are all created as Jobs I believe) you can right click in the Enterprise Managers Management/Jobs Tree and select All Tasks/Generate SQL Script

Hope this helps.

Quote:

Originally Posted by rdfanta

Greetings one and all,

I hope some here can help me.

We are currently running SQL Server 2000 on 2 different servers. The first server was an upgrade from SQL 7 so the data, etc are in a directory named MSSQL7. The second sever is newer and larger (Disk and Memeory) and was a straight install, so the data is in MSSQL.

I am trying to move everything from the old server to the new one. The databases are easy as well as the users. I can not get my DTS packages, DB Maintenance, and SQL Server Agent jobs from the old one to the new one.

Any ideas?? We are running out of room on the old server and need to get this moved over asap.

I look forward to hearing from someone.

Ray

|||Mr Byte,

Thanks for the info. The only Item that gives me that option is the SQL Server Agent Jobs. But I get an error when trying to run the script because the DB Maintenance Job does not exist.

For the DTS Packages, I am trying to save them as Structured Storage files or Visual Basic files. But I have not figured out how to read them back in

Ray