jjoz
asked on
Consideration in consolidating 2x old SQL Server 2000 into 1x new powerful SQL Server 2008 ?
Hi All,
I'm in the process of consolidating the old Database server into SQL Server 2008 VM, what could be the things that I need to consider before I go ahead and attach detaching the DB instances into the new 2008 server ?
cmiiw:
After I've done the restore for each instances, I'll set the compatibility level to SQL 2000, and run DBCC UPDATEUSAGE (0);
I'm in the process of consolidating the old Database server into SQL Server 2008 VM, what could be the things that I need to consider before I go ahead and attach detaching the DB instances into the new 2008 server ?
cmiiw:
After I've done the restore for each instances, I'll set the compatibility level to SQL 2000, and run DBCC UPDATEUSAGE (0);
Io as it will be running virtually. And I've had applications that wouldn't connect. So I'm always testing this and moving db by db.
hi
i agree with p_nuts ive had problems to connecting with apps after moving to sql 2008 from 2000
you should do a POC first and see that you have no problem using your apps before migrating complitly
i agree with p_nuts ive had problems to connecting with apps after moving to sql 2008 from 2000
you should do a POC first and see that you have no problem using your apps before migrating complitly
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
oh, so if I have a very old legacy application that can only uses the old SQL Server 2000 T-SQL, then I won't be able to use it eventhough I set the compatibility level to 80 --> SQL Server 2000 compat level ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
By the way, if your app is playing by the rules it will just work, no matter what compat level you assign.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks !