tool for migrate sql2000 to sql2008

I wonder if there exist any application and which is the name for migrating the database from an older to a newer version (eg SQL 2000-2008) and whether this also changes settings in the Stored Procedure and Functions if one of them has the old programming ANSI 89
enrique_aeoAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ste5anSenior DeveloperCommented:
You can normally attach the database files to a SQL Server 2008 server.

Or create a full backup on your old box and restore it on the new box.

In all cases: check the database compatibility level. It should be SQL Server 2000 (80).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
David ToddSenior Database AdministratorCommented:
Hi,

Essentially, the upgrade is to restore a database on the new version of SQL.

There are a couple of things that we're advised to do once a database restore has been completed. I've found this is especially true when restoring a SQL 2000 database on SQL 2005 or SQL 2008.

The statistics are supposed to be updated.

And running dbcc updateusage is often needed.

If you are after the upgrade adviser try here. http://www.microsoft.com/en-nz/download/details.aspx?id=11455

And here https://msdn.microsoft.com/en-us/library/ms144256(v=sql.120).aspx

HTH
  David
Vitor MontalvãoMSSQL Senior EngineerCommented:
You don't need a tool for that apart from the Upgrade Advisor that comes with SQL Server 2008. You just run it over the SQL 2000 database to get a report about the compatibility. If the report is positive then you just need to backup (or detach) the MSSQL 2000 database and restore (or attach)  it in the MSSQL 2008 instance. The last step is to set the compatibility of the migrated database to 10 (SQL 2008).

DTS's and Jobs can be migrated as well. Complex DTS might need to be rewritten in Integration Services.
Logins need to recreated in the new instance.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.