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/details.aspx?familyid=451FBF81-AB07-4CCB-A18B-DA38F6BCF484&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 SQL
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 your
> SQL Server 2000 database, and have it scan it. The report and documentation
> are very comprehensive.
> http://www.microsoft.com/downloads/details.aspx?familyid=451FBF81-AB07-4CCB-A18B-DA38F6BCF484&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
> >
>
>|||On Mon, 13 Feb 2006 04:26:16 -0800, Gé Brander wrote:
>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?
Hi Gé,
I just posted a reply to your question in the Dutch group
microsoft.public.nl.sql.
--
Hugo Kornelis, SQL Server MVP

Migrate SQL Server from 64Bit platform to 32Bit

Hi, All:

We have to migrate several 64Bit SQL Servers to 32Bit platform. Due to the 64Bit source systems are all production system, the downtime is too limited. So we can only get the DB files via Detach way. Among the source systems, both SQL2000 and SQL2005 exist.

My question are:

Is it possible to migrate the DB from 64Bit to 32Bit via Detach/Attach?

If ok, how to do that?

Any info will be highly appreciated! Thanks!

Best Regards,

Kevin

See the response to the same question here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1066278&SiteID=1

Migrate SQL Server from 64Bit platform to 32Bit

Hi, All:

We have to migrate several 64Bit SQL Servers to 32Bit platform. Due to the 64Bit source systems are all production system, the downtime is too limited. So we can only get the DB files via Detach way. Among the source systems, both SQL2000 and SQL2005 exist.

My question are:

Is it possible to migrate the DB from 64Bit to 32Bit via Detach/Attach?

If ok, how to do that?

Any info will be highly appreciated! Thanks!

Best Regards,

Kevin

Hi Kevin.

The on-disk layout of database files is the same for 64bit and 32bit databases, there's no difference...you can freely attach/detach, backup/restore, etc. to/from 32bit/64bit systems and vice-versa at will with no issues. Of course, this assumes you are moving the between supported migration/compatibility instances...i.e. you couldn't move a Sql 2005 64bit database to a Sql 2000 32bit system...

HTH

|||

Hi, Chad:

Greate thanks for your reply!

Best Regards,

Kevin