It shows that you are unregistered. Please register with us by clicking Here
It shows that you are unregistered. Please register with us by clicking Here
 |
|
 |
 | Register - FAQ - Today's Posts - New Posts - Support - Search |  |
10-17-2006
|
#1 (permalink) |
|
Senior Member
Join Date: Oct 2006
Age: 22
Posts: 176
|
How hard is it to upgrade SQL code to SQL 5?
I found out that it's not backwards compatible completely. How much work does it take to go though the SQL functions on our websites to handle an SQL upgrade? Is there any software that can automate this?
__________________
Don't gain the world and lose your soul, wisdom is better than silver or gold.
~Bob Marley~ |
|
|
|
|
|
10-17-2006
|
#2 (permalink) |
|
Senior Member
Join Date: Jul 2006
Location: Redmond, WA
Posts: 1,064
|
Re: How hard is it to upgrade SQL code to SQL 5?
it depends. if you have DTS then you may have a lot of work ahead of you since 05 does not support DTS. it was changed to SSIS and it's not exactly the same (and not that different).... just enough inconsistencies to make migrating your DTS to an 05 server a smooth transition.
__________________
NOSH1T/LOSTGIRLWONDERINGV4 the only real mistake is the one from which we learn nothing (John Powell) |
|
|
|
 |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Are you going to upgrade to phpBB3? | SMF For Free | Forum Management | 2 | 10-12-2006 12:18 AM |
| Trying to upgrade | lisah746 | Forum Management | 4 | 08-03-2006 01:31 AM |
| Help, problem with upgrade | lisah746 | Forum Management | 4 | 07-30-2006 04:52 AM |
| Peep upgrade... | cromansk | All Things General | 6 | 06-01-2006 12:18 AM |
Linear Mode
