Showing posts with label bug. Show all posts
Showing posts with label bug. Show all posts

Friday, March 23, 2012

Move/Upgrade SQL 6.5 Databases to SQL 2K

I am running into problems when attempting to move
databases from SQL 6.5 to SQL 2K. There is a known bug in
SQL2K, SP3a when using the migration wizard. The work
around involved installing 6.5 on a Windows 2000 Server
but we ran into problems with that as well. Microsoft
actually removed their White Paper on this subject from
their site. Does anyone know of a good information source
for instructions on how to do this?Try to detach the databases from source 6.5 server, copy
the your database mdf and ldf file to your destination
server server and attach the database. Also look into
moving your logins account to that server
>--Original Message--
>I am running into problems when attempting to move
>databases from SQL 6.5 to SQL 2K. There is a known bug
in
>SQL2K, SP3a when using the migration wizard. The work
>around involved installing 6.5 on a Windows 2000 Server
>but we ran into problems with that as well. Microsoft
>actually removed their White Paper on this subject from
>their site. Does anyone know of a good information
source
>for instructions on how to do this?
>.
>

Monday, March 12, 2012

Move SQL 2000 Data To SQL 7

We have a problem with our SQL 2000 server which we know is a product bug.
Is there anyway of importing, Copying the sql 2000 table back down to SQL 7 until the issue is resolved,
many thanksMy first suggestion would be the DTS Wizard (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_tools_wiz_9e5g.asp). You can use a Linked Server (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_4uuq.asp), but it is a lot more work than a simple DTS package that does the same job in most cases.

-PatP