Importing old data to new database

[robert]

New user

I have installed sql 7 on a new computer having trouble getting database
to work with old data
after installing sql 7 I copies old database to the data dir under MCSQL7
when I go to enterprise manager I only see default databases
Do I have to import it ,I thought since its in native format it would be
recogize it.

[Andrew Prosser]

"robert" <robert9@telus.net> wrote:
>
>New user
>
>I have installed sql 7 on a new computer having trouble getting database
>to work with old data
>after installing sql 7 I copies old database to the data dir under MCSQL7
>when I go to enterprise manager I only see default databases
>Do I have to import it ,I thought since its in native format it would be
> recogize it.

SQL Server cannot magically 'pick up' databases because they happen to reside
in a directory, you need to do the following for each of your databases;

Detach the datafiles for each of your old databases;

sp_detach_db my_database_name

Now copy these files to your new machine.

In the new server run for each database;

CREATE DATABASE database_name
ON PRIMARY (FILENAME = 'c:\my_database_name.mdf')
FOR ATTACH

That should be that.