ADO & SQL 7.0

[vidkrish]

I have a database in SQL Server 6.5.
Now I have to install SQL Server 7.0 on the NT Server.
Please let me know as to how the database can be transfered from SQL 7.0 to SQL 6.5.
I have used the ADO in Visual Basic 6.0 with SQL 6.5, now upgrading to SQL 7.0 , should

not give me problems, I guess.

Please let me know.
I wolud really appreciate the help.

Thanks,
Vidya.

[JHausmann]

You're going to want to use the upgrade wizard (?) that comes with SQL Server 7.0

There's far too many things changed between 6.5 and 7.0 to do it any other way.

[vidkrish]

Thanks for the reply.
I actually have SQL 6.5 on the drive c:\ on
the server, but now I want to install SQL 7.0
on the other drive d:\ on the same server.
Please let me know if I can install SQL 7.0 a fresh & then transfer the database from SQL 6.5 to SQL 7.0. Hope it could go through pretty fine , with no problems.

Thanks,
Vidya.

[Jamppa]

You can install 7.0 on the 6.5. Just not select selection upgrade in the installation wizard. So you can have both installed and you can switch from one to another depending on your needs. Databases can be upgraded also during the 7.0 installation. Alternatively you can use 7.0 data import to import 6.5 databases to different lacation in 7.0 form.

Hopefully that will help you!

[vidkrish]

Hi there,

Thanks a lot for the reply.
Due some problems my SQL Server 6.5 does not run. So on another drive on the server I plan to install SQL Server 7.0.
Please let me know if I can still transfer the database from SQL Server 6.5 to 7.0.
I will greatly appreciate your help.

Thanking you,
Vidya.

[JHausmann]

I'd be real careful about installing 7.0 on a production 6.5 server machine. 7.0 requires a different set of data drivers which may not be compatible with clients you might have out there....