Post reply

Attaching Databases

  • October 2, 2003 at 4:48 pm

    #64736

    Is it possible to attach a database created with SQL Server 2K to an SQL Server 7.0?

    Can a backup of a SQL Server 2K database be restored (forcing) onto an SQL Server 7.0

    database?

  • October 2, 2003 at 5:49 pm

    #476893

    No. The only way to move a SQL Server 2000 database to a SQL Server 7.0 server is by using Data Transformation Services (DTS).

    --Jonathan



    --Jonathan

  • October 2, 2003 at 7:13 pm

    #476896

    Or the traditional way, BCP.

  • October 2, 2003 at 7:21 pm

    #476899

    quote:

    Or the traditional way, BCP.

    bcp is for copying data, it will not create any objects.

    --Jonathan



    --Jonathan

  • October 2, 2003 at 7:34 pm

    #476902

    You are right. I should say script all objects from your original database and create them in SQL Server 7.0 database, BCP data out from SQL Server 2000 database and BCP in into database in SQL Server 7.0.

  • October 2, 2003 at 7:40 pm

    #476903

    quote:

    You are right. I should say script all objects from your original database and create them in SQL Server 7.0 database, BCP data out from SQL Server 2000 database and BCP in into database in SQL Server 7.0.

    That sounds a lot like DTS, only more difficult.

    --Jonathan



    --Jonathan

  • October 2, 2003 at 8:06 pm

    #476905

    As I said, Traditional way.

Viewing 7 posts - 1 through 6 (of 6 total)

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