Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Duplicating SQL Server 7.0

Duplicating SQL Server 7.0

Duplicating SQL Server 7.0


Is there a simple way to copy a SQL7.0 database from one machine to another?

I have a WinNT server, SP5, with live data in SQL Server 7.0 format. My development machine is a Win98 with SQL Server desktop installed (not Access/MSDE). In order to work with 'real-world' data w/o corrupting it, I need to copy daily data files to the laptop.

No, I cannot install WinNT on the laptop. (Well, someone was gonna ask <grin!>.)

Literacy in this area is obviously not one of my strong suits, but I've not been able to replicate/duplicate/whatevercate this data. BCP doesn't work, as the primary keys do not coincide. I've tried direct 'insert into . . .' statements with no success.

What I need is a mirror of the day's activity that can be moved down to the laptop for significant trouble-shooting. Anyone willing to abuse me with a solution?

Make a good day . . .
. . . barn

RE: Duplicating SQL Server 7.0

Hi Barn,

Here's the way we usually do it. Not too elegant but is quite practical for us.

1. Export SQL Server database to Access.
2. Use database scripting to build script to later create tables and indexes on your debugging machine.
3. Import Access tables into newly built SQL Server database.


RE: Duplicating SQL Server 7.0


I had a similar problem recently. SS7 has two stored procedures which work like a dream:

sp_detachdb & sp_attachdb (I think).

Look up the help on these. I create an empty smalll db in the target server. Used sp_detachdb from my initial db, copy the physical files from and to the differing machines. Used the attach procedure on the target machine. It worked a dream.

Read the help - theres differing ways you can use them.


RE: Duplicating SQL Server 7.0

1. The easiest way is to copy your data files exactly in the same directory as in the 1st server, the 2nd server can recognize them automatically. (Try it, it's amazing!)
2. Another way is using DTS.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close