Wednesday, March 28, 2012

Migrating databases SQL 2000 to SQL 2005

What sort of problems can I expect when moving my SQL 2000 databases to the
SQL 2005 platform?
Must there be an adaption of code for some of the objects (sp, view, udf
etc), or will it work fine when I put the database compatibility level to 8.
0?
--
MCDBA 2000
MCSE 2000Everything that you need to know about upgrade issues with an existing
database can be found in the Upgrade Advisor. Download it, point it at your
SQL Server 2000 database, and have it scan it. The report and documentation
are very comprehensive.
http://www.microsoft.com/downloads/...&displaylang=en
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"G Brander" <GBrander@.discussions.microsoft.com> wrote in message
news:3AAD007C-0540-4948-A120-5136CC7D5BF4@.microsoft.com...
> What sort of problems can I expect when moving my SQL 2000 databases to
> the
> SQL 2005 platform?
> Must there be an adaption of code for some of the objects (sp, view, udf
> etc), or will it work fine when I put the database compatibility level to
> 8.0?
> --
> MCDBA 2000
> MCSE 2000
>|||Thanks for your answer, but I am not talking about instances, but databases.
I want to migrate several SQL Server 2000 databases to a SQL Server 2005
database server. I do not want to upgrade my SQL Server 2000 instance tot SQ
L
Server 2005.
--
MCDBA 2000
MCSE 2000
"Michael Hotek" wrote:

> Everything that you need to know about upgrade issues with an existing
> database can be found in the Upgrade Advisor. Download it, point it at yo
ur
> SQL Server 2000 database, and have it scan it. The report and documentati
on
> are very comprehensive.
> http://www.microsoft.com/downloads/...&displaylang=en
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
>
> "Gé Brander" <GBrander@.discussions.microsoft.com> wrote in message
> news:3AAD007C-0540-4948-A120-5136CC7D5BF4@.microsoft.com...
>
>|||On Mon, 13 Feb 2006 04:26:16 -0800, G Brander wrote:
[vbcol=seagreen]
>What sort of problems can I expect when moving my SQL 2000 databases to the
>SQL 2005 platform?
>Must there be an adaption of code for some of the objects (sp, view, udf
>etc), or will it work fine when I put the database compatibility level to 8.0?[/vbc
ol]
Hi G,
I just posted a reply to your question in the Dutch group
microsoft.public.nl.sql.
Hugo Kornelis, SQL Server MVP

No comments:

Post a Comment