importing a SQL Server 7.0 database to a SQL Server 7.0 database 
Author Message
 importing a SQL Server 7.0 database to a SQL Server 7.0 database

Hi All,
    I am new to SQL Server and Windows in general. I was given what is
supposed to be a SQL Server 7.0 database on a cd. The only file on the
cd is named databasename.db. I have read and reread the BOL and the
SAM SQL Server book and I can't find a reference to a .db file type
nor can I get SQL Server to import the file. I don't think that it was
a bulk copy or a bcp. I also don't have the option of asking the
file's creator since he is no longer available. So am I missing
something basic or is the file junk. Any help will be appreciated.


Fri, 17 Dec 2004 05:34:09 GMT
 importing a SQL Server 7.0 database to a SQL Server 7.0 database

While there are standards for SQL Server file names, the conventional names
are not requirements.

My first guess would be that it is a .mdf (renamed of course) file, that you
can use via the sp_attach_db system stored procedure. My second guess would
be that is a backup of the database, which you can restore via the RESTORE
command.

Documentation on both the sp_attach_db system stored procedure and the
RESTORE command is available in the SQL Server 7.0 Books Online.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.


Quote:
> Hi All,
>     I am new to SQL Server and Windows in general. I was given what is
> supposed to be a SQL Server 7.0 database on a cd. The only file on the
> cd is named databasename.db. I have read and reread the BOL and the
> SAM SQL Server book and I can't find a reference to a .db file type
> nor can I get SQL Server to import the file. I don't think that it was
> a bulk copy or a bcp. I also don't have the option of asking the
> file's creator since he is no longer available. So am I missing
> something basic or is the file junk. Any help will be appreciated.



Fri, 17 Dec 2004 06:25:08 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Move an Database from an SQL 7.0 server to an other SQL 7.0 server

2. Importing SQL Server 7.0 database to SQL Server 2000

3. Is there any way to convert sql server 2000 database to sql server 7.0 database

4. SQL Server 7.0 on NT Server to SQL Server 7.0 on win2k Pro

5. SQL Server 7.0 on NT Server to SQL Server 7.0 on win2k Pro

6. SQL Server 7.0 on NT Server to SQL Server 7.0 on win2k Pro

7. SQL Server 7.0 on NT Server to SQL Server 7.0 on win2k Pro

8. Seting SQL 6.5 database as linked server in SQL 7.0 database

9. Reestoring a SQL Server 2000 database to SQL Server 7.0

10. Copying database from SQL server 2000 to remote SQL server 7.0

11. Restoring SQL Server 7.0 database to SQL Server 2000 Environment Question

12. Copying database from SQL server 2000 to remote SQL server 7.0


 
Powered by phpBB® Forum Software