Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-05-06 : 08:09:22
|
| Shashank writes "1.What are the problems which are encountered while migrating the data from sql server 7 to sql server 2000.2.Steps required to migrate the data from sql server 7 to sql server 2000." |
|
|
akus@mail.com
Starting Member
3 Posts |
Posted - 2005-05-24 : 19:57:55
|
| Hi, I ve started a SQL server migration project and have found 2 specific issues so far.The best instructions I have found were on this sitehttp://www.sqlteam.com/item.asp?ItemID=94651. If you have order by and select distinct in same query you MUST include the order by field in the select distinct list.2. I found code using result of a subquery returning only int values being used as a value against a varchar in where clause. In sql 7 this works without casting the subquery result into varhcar. in 2000 this is not anymore allowed. If you have found any other coding (or other) issues with the compatibility or performance please post them here :) |
 |
|
|
|
|
|
Data Migration from Sql Server 7 to Sql Server 2000