July 18, 2003 at 4:18 am
I have a requirement to migrate two version 6.5 and six version 7 servers and databases to one sql2k server. I have read that you can only use the upgrade wizard to move 6.5 to the default instance. Once I have my first 6.5 server migrated to the default instance of sql2k, can I rename this to become a named instance thus enabling me to migrate the next 6.5 server to the default instance and then continue to use this iteration for the other six version 7 servers ? If not has anyone any ideas of how I would go about doing this task ?
July 18, 2003 at 7:04 am
quote:
I have a requirement to migrate two version 6.5 and six version 7 servers and databases to one sql2k server.
You can't rename instance.
Are the databases's name identical in both SQL Server 6.5? If not, you can migrate them into same instance. If yes, You need install second instance (named instance) and use sp_detach_db and sp_attach_db to move first upgraded 6.5 databases into second instance and then upgrade second SQL Server 6.5 databases.
Upgrade SQL Server 7.0 is much easy than 6.5. Use sp_detach_db and sp_attach_db to move the databases.
it is recommended that you repopulate full-text catalogs and update statistics and perform database optimization.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply