Link to home
Start Free TrialLog in
Avatar of jjoz
jjozFlag for Australia

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);
Avatar of p_nuts
p_nuts
Flag of Netherlands image

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
SOLUTION
Avatar of Alpesh Patel
Alpesh Patel
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jjoz

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
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jjoz

ASKER

thanks !