Hi,
Aim
—-
a. doing a migration (or upgrade) of SQL 6.5 database to SQL 2000 and later on to SQL 2005.
b. To build the entire system in new platform, in Windows 2003 server with SQL Server 2005.
Current Environment:
———————-
OS: Windows NT Server 4.0 with SP6a
SQL Server: 6.5
Database Size: around 300MB (and only one database)
The application was developed in Visual Studio 5 platform and with VB5 + Visual C++
Problem with Current Environment/Platform:
——————————————-
a. Operating System is getting old and hence no driver for new hardware is available in market
b. To use the new hardware, it is needed to migrate the entire platform in Windows 2003 Server platform. The existing hardware is with Pentium Pro machines (you know how old these are!!!).
Our Study and Progress:
————————-
a. The application is ok with Windows 2003 Server (hopefully, as such, we could install all the applications). And, the provided DLLs and OCXs were installed in the Windows 2003 Server as well.
b. There might be one problem with the connectivity. Present system is using one ODBC supplied by the vendor at that point of time. And our understanding is, we might need to have ODBC for this application to get connected to database server i.e. SQL 2000/2005. But, might not be needed as well, if that is there in OS as built in (I am not sure).
WHAT WE NEED ARE:
——————
a. Step-by-step instructions about how to solve the MIGRATION or UPGRADE issue. A detail outline on the hardware environment and software environment would be much beneficial as well. We’ve found and READ throughly many articles in net, but not sufficient for us to move!!!
b. Which way should we go, upgrade the system or only migrate? As the 6.5 server is only having one database that we are talking about and we prefer to MIGRATE the db first, then install OS (Windows 2003 Server Enterprise Edition with 50 licenses), install SQL 2005 and restore the migrated db into the newly installed machine.
Looking forward.
Regards//Biplob