| neuralocity@hotmail.com 2006-01-14, 3:23 am |
|
Previously, I am trying to replicate data from a SQL Server 7.00.1063
to a new SQL
Server 2005 standard edition installation. After a transaction
publication was created on the 7.0 server, when I attempted to create a
new subscription on the 2005 installation,using the New Subscription
Wizard, via a SQL Server authentication connection, I received a dialog
box with:
Cannot connect to ServerX
Additional Information
Failed to connect to server ServerX.
(Microsoft.SqlServer.ConnectionInfo)
This SQL Server version (7.0) is not supported.
(Microsoft.SqlServer.ConnectionInfo)
...but according to
http://msdn2.microsoft.com/en-us/library/ms143699.aspx this should be
supported. Any ideas what I could check for?
Since then I came up with an ok workaround, but I would still prefer an
answer to the above question:
1. shutdown the SQL 7.0 server (detaching database(s) might also work)
2. copy the .MDF and .LDF files, for each database, over to the new SQL
2005 server
3. restart the SQL 7.0 server (only if shutdown occurred)
4. attach the database(s) to the new SQL server
5. check the integrity of each database
6. switch the compatibility mode from 7.0 to 2005
Use this script to check the integrity (you will need to modify it to
suit your specific needs):
USE DataBase1
go
sp_dboption DataBase1, 'single user', true
GO
DBCC CHECKALLOC
GO
DBCC TEXTALL
GO
DBCC CHECKDB
GO
DUMP TRANSACTION DataBase1 WITH NO_LOG
GO
DBCC CheckTable (Table1)
GO
DBCC CheckTable (Table2)
GO
DBCC CheckIdent (Table1)
GO
sp_dboption DataBase1, 'single user', false
GO
Cheers,
Michael
|