Post reply

Are Yukon Databases compatible with SQL Server 2000?

  • August 31, 2005 at 9:57 am

    #168152

    I expect the answer is NO, but is there any flag or way to backup a Yukon database so it can be restored on SQL Server 2000?  Especially if takes no advantage of SQL data types?

     

  • September 1, 2005 at 3:09 am

    #586754

    In my experience there you cannot directly restore data from SQL 2005 into a SQL 2000 database (although you can do this the other way round).

     

    However, you should be able to use the Copy Database Wizard to transfer objects and data.  If you want to do this on a semi-regular basis then you can also use Integration Services/DTS.  And remember that you can also replicate data to SQL 2000, so you could set up a snapshot publication on your SQL 2005 database. This can be scheduled too.

  • October 10, 2005 at 5:52 am

    #596235

    Hi

    Can you please guide me on how to use Copy database wizard in SQL 2005. As incidentally I have upgraded my default instance of SQL server 2000 to 2005 and now I want all the DB's to be restored back to 2000 format on a different instance.

    Thank you

    dbhartiya

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply