Very Computer

Quote:> I could sure use some help with this one.  My client is running SQL 6.5.  I
> need to replicate his database on my home development machine (SQL 7) in
> order to create some reports.  Being fairly new to SQL server, I created a
> full backup to a .dat file at the client site.  Is there any way to get this
> database into my SQL 7 environment????  Upgrading the client to 7.0 is not
> an option.

A. No and no.

If you have a SQL 6.5 dump file then you will have to load it into a SQL 6.5 server
first.

If you have a device file then you will have to install SQL 6.5 and then DISK REINIT
and REFIT (details in the books online) it into SQL 6.5.

The ONLY ways to transfer SQL 6.x databases into SQL 7.0 are :-

1.  Use the Upgrade Wizard.  This is the best option.  It requires a running SQL 6.5
system to extract from.

2.  Use the DTS object copy tools in SQL 7.0 to copy objects from SQL 6.5.  Note this
doesn't copy defaults/constraints etc.

3.  Script the SQL 6.5 database using SQL Enterprise Manager scripting.  Re-create it
using the script on SQL 7.0.  Use BCP to copy the data.

===

v1.00 1999.05.17
Applies to SQL Server versions  : 7.0
FAQ Categories                  : Installation and Upgrades
Related FAQ articles            : n/a
Related Microsoft Kb articles   : n/a
Other related information       : n/a
Authors                         : Neil Pike

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please reply only to newsgroups)
 SQL FAQ (428 entries) see
 forumsb.compuserve.com/vlforums/UK/default.asp?SRV=MSDevApps (sqlfaq.zip - L7 - SQL
Public)
 or www.ntfaq.com/sql.html
 or www.sql-server.co.uk
 or www.mssqlserver.com/faq

Thanks again.

* Sent from Devdex.com http://www.devdex.com The Web Developers Index *
The world's largest index site for Microsoft web technologies.

* Sent from Devdex.com http://www.devdex.com The Web Developers Index *
The world's largest index site for Microsoft web technologies.