Sql2K to Sql 7

Results 1 to 2 of 2

Thread: Sql2K to Sql 7

  1. #1
    Join Date
    Dec 1969

    Default Sql2K to Sql 7

    Help,<BR><BR>I need to load a Sql 2000 db onto a Sql 7 server.<BR><BR>I don&#039;t have access to the Sql 7 server at the moment, but need to know how to do this.<BR><BR>Sql 7 can&#039;t attach to a Db (I think). So can it restore from a Sql 2000 Db?<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default I think you'd have to use DTS

    you can&#039;t restore or attach, so you&#039;d have to import/export.<BR><BR>Ideally, script the tables and create them first, changing the SQL where necessary to &#039;downgrade&#039;, then Export. that way your keys and relationships should transfer too.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts