Duplicating SQL Server 7.0

[databarn]

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>

 

[johnk]

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

 

[calahans]

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

 

[xgege]

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.