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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SqlServer Versions Compactablity

Author  Topic 

NatureTrack
Starting Member

1 Post

Posted - 2010-08-31 : 03:18:40
Iam using a sqlserver 2000 in one system. but i want to upload in two different versions on Sql Server ( 2005 & 2008) in different systems. But the changes wil be done in Sql Server 2000 and it will be updated in the above different versions for the next updates.

Is any compactablity / version mismatch will occur! pls guide

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2010-08-31 : 12:39:46
usually most things would work fine but there could be some things that may break. Run the SQL Upgrade Advisor - both 2005 and 2008 on your 2000 database and see which features break.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page
   

- Advertisement -