steps to consider while migrating SQL server 2000 store proc to Sql server 2005

Question

steps to consider while migrating SQL server 2000 store proc to Sql server 2005

sabarichandru

SSCommitted

Points: 1704
More actions
July 27, 2010 at 11:40 am

#238134

Hi everybody,
from yesterday onwards im working in migration project which involves DTS package and lots of store proc to be migrate from 2000 to 2005/2008. but my concern i don have experience in migration project . so can anybody help me what are all the steps to consider before proceeding with this project . because coming Friday im having the client interview then only i can work on this project . so i will be happy if anybody help me.
i need what are all the steps to consider for migrating DTS to SSIS and
subsequently for Store Procedure also .
Note : pls send seperate steps for both .
Thanks in Advance!
Sabarinathan.C

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

For stored procedures, I would start with the Database Upgrade advisor. That will run checks on your database to help determine what needs fixed prior to upgrade.

For DTS packages, I would start at the Database Upgrade advisor. Not to determine the upgrade-ability of the package but to ensure that the underlying objects will be good in the new environment.

While doing that, I would get a book on SSIS to help learn the new facets of SSIS. Things have changed substantially.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

sabarichandru SSCommitted Points: 1704 More actions · Answer 2

Hi ,

Thanks for your quick reply. here my problem is i joined a new project but no prior experience in upgrading DTS to SSIS project. this is on going project in client place . after the client interview i will also be part of this project.

before that i like to know what are all the necessary steps to care while upgrading the DTS to SSIS .so i can clear my client interview.

can anybody give some valuable points to me .

Note : i'm having 4+ yrs of Exp in Sql server 2005/08 but don have prior Experience in upgrading DTS to SSIS .

i'm googling in internet but if anybody came across upgrading project it will be great helpful to me .

its very urgent

Thanks in Advance!

Sabarinathan

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

There is no single answer for your question.

It is best to be honest in your interview. If you don't have the experience and you try to answer as if you do, then you are mis-portraying yourself.

With DTS to SSIS conversion the process will depend on the needs of the package.

Basics though include doing it in a development environment. Test your package thoroughly. Compare the results of the dts package to the ssis package and confirm that they are providing the same results.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Ron McCullough SSC Guru Points: 63877 More actions · Answer 4

Using BOL check the following:

i. SQL Server 2005 Books Online (September 2007)

sp_dbcmptlevel (Transact-SQL) or

http://technet.microsoft.com/en-us/library/ms178653(SQL.90).aspx

2. Backward Compatibility

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/8c69df2a-02e7-4665-a3ee-4f038f50b4ac.htm

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

sabarichandru SSCommitted Points: 1704 More actions · Answer 5

Hi Jason,

i agree with your point . but i don't have option here. if anything comes to development i can handle and manage easily because i'm having Experience in 2005/2008 but not in 2000 . if i got any basic ideas so i can proceed further on it .

anyway thanks dude for guiding me .

regards,

Sabarinathan

sabarichandru SSCommitted Points: 1704 More actions · Answer 6

Hi Ron,

Thanks for your effort and time to response my queries. sure i will go through the link and get back to you .

Regards,

Sabarinathan