469,950 Members | 2,480 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,950 developers. It's quick & easy.

Compatibity of SQL server 2000 and 2005 database!

Hi All,


Can the database created in SQL Server 2005 be used in SQL Server 2000?
I know older version of database is compatible with newer version, but I am not sure the other way around.

Any ideas?

Thanks.
-Jason.
Feb 15 '08 #1
1 935
ck9663
2,878 Expert 2GB
Hi All,


Can the database created in SQL Server 2005 be used in SQL Server 2000?
I know older version of database is compatible with newer version, but I am not sure the other way around.

Any ideas?

Thanks.
-Jason.
I tried to backup my 2005db and restore it in 2000, it did not work. You can not access 2005 with 2000's Enterprise Manager,either. If you did not use any 2005-specific functions/features, you can just transfer objects using SQL 2005's Management Studio to your sql 2000.

Good luck

-- CK
Feb 15 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

17 posts views Thread by Danieltbt05 | last post: by
10 posts views Thread by amjad | last post: by
14 posts views Thread by Developer | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.