Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sqlbuddy
Starting Member
27 Posts |
 Posted - 2009-05-26 : 10:33:08
|
| Hi, I am doing a migration from a SQL Server 2000 instance to SQL Server 2005 instance. Could anyone tell me what all database objects in the system databases (Master, Model, Msdb and Tempdb)should be migrated to SQL Server 2005 instance? Thank You,YoursSQLBuddy |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-26 : 10:57:09
|
If you UPGRADE your SQL Server instance, the install program will do the migration for you.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
Sqlbuddy
Starting Member
27 Posts |
Posted - 2009-05-26 : 11:13:01
|
| Hi Peso, Thank you very much for your reply. But I am not doing an in-place upgrade. I am doing a side by side migration i.e my SQL Server 2005 instance lies on a seperate machine ? Thank you,Best Regards,SQLBuddy |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-05-26 : 11:23:20
|
| logins are held in master.jobs are held in msdbYou'll have to do something with dts packages and if you've made the mistake of holding them in the server they will be in msdb.linked servers.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Sqlbuddy
Starting Member
27 Posts |
Posted - 2009-05-26 : 11:52:08
|
| Hi Peso, Thank you very much.Best Regards,SQLBuddy |
|
|
|
Sqlbuddy
Starting Member
27 Posts |
Posted - 2009-05-26 : 11:56:34
|
| Hi NR, Thank you very much for your reply. I am using the stored procedure sp_help_rev_login to transfer the logins and I am scripting the jobs and Linked Servers to transfer them to SS2005 instance.I am using DTS Xchange to transfer the DTS packages to the new server.But apart from transfering the Master Stored Procedures should we transfer any other system database objects? Thank you,Best Regards,SQLBuddy |
|
|
|
|
|
|
|
|
SYSTEM OBJECTS TO MIGRATE FROM SS2K TO SS2K5