convert sql7.0 MDB/LDB -> sql2k

[dimitric]

Greetings,

I recently upgraded to SQL2k which failed on the first try so I had to unistall SQL7 and reinstall SQL2k. It worked however how do I get my OLD db into SQL2k. All I have left from 7.0 is my .MDB and .LDB , using the import data wizard, I can't figure out what to use for the 'import from' DSN (since they are just the raw DB files)

any ideas?

 

[tlbroadbent]

Use sp_attach_db. Move the MDF and LDF files to the SQL 2000 data folder. Create and execute a script like the following.

EXEC sp_attach_db @dbname = N'pubs',
@filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf',
@filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs_log.ldf' Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[dimitric]

thanks for your reply. I figured it out..I didn't realize that you could attach using enterprise manager..thanks!