upgrade 2005 - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

upgrade 2005

Author

Topic

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-09-25 : 14:31:59

Upgrading from 2000 to 2005. Just want to know what is going to break. I need to have a plan.
I know DTS is going to break. Any other things?

=============================
http://www.sqlserverstudy.com

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-09-25 : 14:34:13

Queries using systables instead in INFORMATION_SCHEMA views.

E 12°55'05.25"
N 56°04'39.16"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-09-25 : 14:46:07

Download the upgrade advisor tool from Microsoft that checks for the things that might break. Run it against your database, then make changes as necessary.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-09-25 : 14:51:20

There is no reason for DTS to break.

DTS is fully supported in SQL Server 2005, but you do need to install the legacy support components; they are not installed by default.

You will need to install the SQL Server 2000 DTS Designer Components from the SQL Server 2005 Feature Pack if you want to be able to create or modify DTS packages in SQL Server 2005.

CODO ERGO SUM

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-09-25 : 15:37:51

http://weblogs.sqlteam.com/mladenp/archive/2007/07/10/60252.aspx

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-10-01 : 10:44:58

I have installed SQL Server 2000 DTS Designer Components, when i try to open a package. it will pop up errors.

=============================
http://www.sqlserverstudy.com

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-10-01 : 10:46:17

as usual your description of the problem is impecable.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-10-01 : 10:58:34

Error source: M DTS
Error description: DTS host failed to load or save the package properly.
I clicked ok

DTS package error
The selected pakcage cannot be opened. DTS designer has been closed.
I clicked ok

SQL server 2000 dts designer components are required to edit dts. installed speacil webdownload.....

=============================
http://www.sqlserverstudy.com

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-10-01 : 11:55:46

looks like DTS is not supported on 2005.
now i have to install visual studio to use IS...damn microsoft.

=============================
http://www.sqlserverstudy.com

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-10-01 : 12:02:05

you can run DTS only in legacy mode but that's it.
also note that you can't modify dts packages in SSIS.
you'll have to completly rewrite your DTS's in SSIS

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-10-01 : 13:17:32

I went to legacy/DTS
try to open the package and it popup up the error. (see previous post)

=============================
http://www.sqlserverstudy.com

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-10-01 : 13:18:41

you can run it not edit it.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-10-01 : 17:01:29

damn MS

=============================
http://www.sqlserverstudy.com

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-10-01 : 17:09:56

I just love it when people blame the tool or company for their lack of knowledge on the product.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources