Thanks Erik,
Your last item seems just what I was looking for. I'll be looking into that one first.
Cheers,
JimN
>>So, I thought, someone has mentioned the "console" before so I'll go use that. Looking around I found Start-->Microsoft SQL Server 7.0-->MSDTC Administrative Console, clicked on it but got 'shortcut not found' (roughly). It was looking for "dac.exe" in WINNT/System32 but it asn't there nor anywhere else.
>
>If you use SQL Server Developer edition, you can use the query analyzer to execute sp_detach_db. After running this, you can make copies of your database and log files, and copy them to any other MSDE or SQL 7 Server, and then run sp_attach_db to attach it to the new server. The equivalents of sp_attach_db, and sp_detach_db are also available through SQLDMO:
>
>oSvroot = CreateObject("SQLDMO.SQLServer")
>oSvroot.Connect("(local)", "sa", "")
>oSvroot.AttachDB("mydatabase", ;
> "c:\mydetacheddatabase.mdf,c:\mydetacheddatabase.ldf")
>
>
>
>If you only need to copy the structure and not the data, then you can 'Script' the database to a file, and then run that script on the target machine.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only