June 10, 2008 at 4:57 am
Hi,
In pursuit of doing a migration of SQL 6.5 database to SQL 2000 or SQL 2005, I've found one of your articles in web. Please see below for our scenario:
Current Environment:
OS: Windows NT Server 4.0 with SP6a
SQL Server: 6.5
Database Size: around 300MB
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, because, in old/existing hardware platform, Windows 2003 Server does not get installed, not even Windows 2000 Server!!! The existing hardware is with Pentium Pro machines (you know how old these are!!!).
Requirement:
a. To build the entire system in new platform, possibly in Windows 2003 server.
b. To migrate the present database (which is in SQL 6.5) in new platform i.e. in SQL 2000 or 2005 (preferable)
Our Study and Progress:
a. The application is ok with Windows 2003 Server (hopefully, as such, we could install all the applications).
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).
c. The provided DLLs and OCXs were installed in the Windows 2003 Server as well.
So, in light of the above mentioned explanation, can anybody be able to help us in getting the issue resolved?
Looking forward.
Regards//Biplob
June 10, 2008 at 6:38 pm
Seems a lot of work to do for this. A couple things for now:
1. Upgrade SQL6.5 to SQL2000 first, then upgrade SQL2000 to SQL2005. You may encounter problem when you upgrade 6.5 to 2000. Need to modify the code.
2. Make the new environment as a testing environment, and test/test/test including application.
3. Ask the application vendor what driver is supported for SQL2005. Should go to SQL2005 not SQL2000.
June 11, 2008 at 8:30 am
And, for code, be sure to check all the NULL checks.... Major change happened there from 6.5 to 7.0
June 11, 2008 at 8:42 am
There is a compatibility mode you can set on the databases as well to have them run as SQL65 for keywords and functions.
June 11, 2008 at 8:45 am
True if you go to SQL 2000, not available for SQL 2005 (for 65 mode, 70 and 80 is)
June 11, 2008 at 8:46 am
one more, change double quotes " to single quote ' if I remember correctly.
June 11, 2008 at 8:33 pm
Hi All,
Thanks a lot for your valuable comments!!! This will indeed add to my study which is ongoing at present!!!
But we are, at the same time, thinking to go for some professionals who can do the migration for us. Can some one give us contacts whom we can knock? Because, the matter is a bit urgent as well!!!
Again many thanks for all of your support.
Regards//Biplob
June 12, 2008 at 7:43 am
Please tell us where you are located. Chances are that there is a SqlServerCentral poster near you that could help or know someone that could help.
Steve
June 12, 2008 at 7:51 am
Thanks Steve!!! We are located in Bangladesh/Dhaka.
Cheers//Biplob
June 15, 2008 at 2:10 am
Hi All,
Anyone can help us in upgrading/migrating a SQL 6.5 database into SQL 2005? The database is having 82 tables and several SPs and others.
The current platform is:
Windows NT Server 4.0 with SP 6a
SQL Server 6.5 with SP 3
an Application Software built in Visual C++ and Visual Basic (VS 5)
We need to know some professionals (may by in perfonal capacity or organization) who can do the work for us which will be a paid service as well 🙂
Cheers//Biplob Chakma
Dhaka/Bangladesh
June 23, 2008 at 2:58 am
I am sure you will be able to find good companies in Dakha. If not, the main IT service providers (Infosys, Wipro, etc) in India generally provide an excellent service and all have offices in Kolkata (Salt Lake) area.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply