Compatibity of SQL server 2000 and 2005 database!

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • jojo41300000
    New Member
    • Apr 2007
    • 32
    #1

    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.
    Tags: None
    • ck9663
      Recognized Expert Specialist
      • Jun 2007
      • 2878
      #2
      Originally posted by jojo41300000
      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

        Comment

        Previous template Next
        Working...