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 |
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
 Posted - 2008-11-23 : 09:19:51
|
| We are planning to migrate SQL Server 2000 to SQL server 2005. We shall be doing in-place upgrade, where the server which has currently SQL 2000, I shall upgrade that 2000 to SQL 2005 database.I am trying to find out what challenges we may face? what differences we may have? Will it affect the business environment?Actually I am currently testing in our test environment everything is fine so far. I believe there will be some issues with the queries that works on 2000 but might throw errors on 2005, either due to syntax that's now invalid or changes to the optimiser. Did anybody face such issues, as I am curious to find out what syntax errors or conversion errors were they? Thanks! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-23 : 10:31:11
|
| I always prefer side-by-side upgrade instead of it. Have you checked microsoft whitepaper for In-place upgrade ? |
 |
|
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
Posted - 2008-11-23 : 15:29:50
|
quote:
Originally posted by sodeep
I always prefer side-by-side upgrade instead of it. Have you checked microsoft whitepaper for In-place upgrade ?
Just wondering what kind of uses we run into, I am testing in our test environment, so far it's going fine. |
|
|
|
hey001us
Posting Yak Master
185 Posts |
Posted - 2008-11-23 : 17:54:07
|
| Based on my experience you need to care following areas:1. ActiveX Script issue if you call SOAP object inside the DTS2. Parameter issue in DTS3. Data type error. (Use data convertor to solve this.)And I too prefer side-by-side methodhey |
|
|
|
|
|
|
sql migration to 2005