Attaching SQL 7 DB to SQL2K 1

[onbeach]

Should I expect any issues other than maintaining the existing compatibility mode when detaching a SQL 7.0 database and attaching it to SQL2000?

 

[sqlturbo]

Besides that, there are more things that you would like to take care off. When you attach a SQL 7.0 database to SQL Server 2000, it upgrades the database and with that come some issues that you may want to check beforehand. Check out FAQ183-1781 for more details.

Two issues that a co-worker come across...

In the Connection strings to a SQL Server 7.0 database it is not necessary to specify "trusted_ connection = yes" to get a trusted connection. In 2K you have to specify that.

DTS packages containing Copy SQL Server Objects tasks, where the source and destination are both SQL Server 7.0 databases, may fail if the source server is upgraded to SQL Server 2000 and the package is executed. Check out "Copy Server Object Tasks" in MSDN for more details.

 

[sunila7]

Hi,

I think u r having less no of columns in the insert list than wht is actually being entered...

insert into OrderDetails (
Username,
AddedLogo,ProductName,
ProductSize,ProductColor,
ProductPrice,LineItemTotal,
TotalOrder,ProductID)
values (
'ladyborg@domain.com',
'../images/logos/lady01.gif, ../images/logos/lady01.gif',
'Solid sports shirts in pique knit, Apron',
'S, One Size',
'Black, White',
1000, 32,100000,
'203, AP-01')

This seems to work.... removed coupe of values from the list

Sunil

 

[onbeach]

sorry for the dup, not thinking clearly. Saw the others but if you have more to offer feel free...thanks again folks.