Re: moving a db

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 07/27/04 

Date: Tue, 27 Jul 2004 15:29:44 -0600

Dave,
You can copy the data over to SQL Server 7 using DTS or BCP.
You can't move the entire database with backup/restore or
sp_detach_db/sp_attach_db due to the version
incompatibilities.

-Sue

On Wed, 28 Jul 2004 09:21:15 +1200, "Dave Bartlett"
<davebartlett429@yahoo.com> wrote:

>How can I move data in a SQL Server 2000 DB to an SQL Server 7.0 DB?
>

Relevant Pages

  • Re: Losing default settings it table fields after database restore
    ... When you originally did your export using DTS did the defaults come across? ... A BACKUP/RESTORE will take everything across so I do not think it is here that things are getting lost. ... using DTS to import from SQL Server to SQL Server (and then Backup ... to make a .bak file of the imported database). ...
    (microsoft.public.sqlserver.dts)
  • Re: Collation Problem any help
    ... If so, you could use DTS in a way similar to what Adam described, although ... If your schema isn't terribly complicated you could also use BCP: ... want your destination collation to be ... Apply the script to a new database using Query Analyzer ...
    (microsoft.public.sqlserver.datamining)
  • Database Users disappered after restore
    ... I am trying to restore a database from one machine to ... I 've tried using Backup/Restore and equally ... using DTS. ... I equally used attach method of transact SQL. ...
    (microsoft.public.sqlserver.security)
  • Database Users disappered after database restore
    ... I 've tried using Backup/Restore and equally ... using DTS. ... I equally used db attach method of transact ... At the end of any of the operations, the database users ...
    (microsoft.public.sqlserver.security)
  • RE: Table backup
    ... The only way to backup a table is to use BCP or DTS to export it somewhere ... Such as a text file or another database. ...
    (microsoft.public.sqlserver.tools)