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 |
|
Ryanmcd
Starting Member
3 Posts |
 Posted - 2008-09-25 : 14:09:12
|
| I am tasked with upgrading a SQL 2000 server upto 2005. The server has a few 1000 dts packages and I was told they wish to do a inplace upgrade on the server. Has anyone done this and anything I can read / look at that will help me with this so I dont have a failed upgrade? |
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2008-09-26 : 01:09:57
|
Hopefully you have a dev server to practice on...Remember NO changes can be made to the packages after the upgrade, but they will still run.After you upgrade your SQL Server to SQL Server 2005, the packages carry over in place and are not upgraded as part of the process. All of your production jobs that call the packages are also carried over without change. Without touching the packages, you can continue to run the 2000 packages since the DTS runtime environment comes over. You'll be able to find your 2000 packages in the Microsoft SQL Server Management Studio under the Management node then Legacy -> Data Transformation Services. The problem is going to be that you'll need to install the SQL Server 2005 Feature Pack (specifically, the Package Designer for 2000) to modify the package after the upgrade. This was not installed by default to give you a smaller surface area in your install. After you upgrade the last node on your SQL Server, the SQL Server 2000 tools are completely removed. Note: Support for the Metadata Repository has been removed in SQL Server 2005 so those packages will not come over. You will need to save those packages into a different storage area like MSDB or the file structure before upgrading your instance. You can do anything at www.zombo.com |
 |
|
|
Ryanmcd
Starting Member
3 Posts |
Posted - 2008-09-29 : 13:30:39
|
| what happens if it has a problem upgrading something in one of the db's on the server? That is does entire upgrade fail, or just the upgrade of that database? |
|
|
|
|
|
|
SQL 2000 to 2005 in place upgrade