Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Duplicating SQL Server 7.0

Status
Not open for further replies.

databarn

Programmer
Sep 19, 1998
202
US
Folk,<br>
<br>
Is there a <i><b>simple</b></i> way to copy a SQL7.0 database from one machine to another? <br>
<br>
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. <br>
<br>
No, I cannot install WinNT on the laptop. (Well, <i>someone</i> was gonna ask &lt;grin!&gt;.)<br>
<br>
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.<br>
<br>
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?<br>
<br>
Make a good day . . .<br>
. . . barn<br>

 
Hi Barn,<br>
<br>
Here's the way we usually do it. Not too elegant but is quite practical for us.<br>
<br>
1. Export SQL Server database to Access.<br>
2. Use database scripting to build script to later create tables and indexes on your debugging machine.<br>
3. Import Access tables into newly built SQL Server database.<br>
<br>
JohnK
 
Hi,<br>
<br>
I had a similar problem recently. SS7 has two stored procedures which work like a dream:<br>
<br>
sp_detachdb & sp_attachdb (I think).<br>
<br>
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.<br>
<br>
Read the help - theres differing ways you can use them.<br>
<br>
C
 
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!)<br>
2. Another way is using DTS.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top