MS SQL Sever 7 to SQL Server 2005 Migration

Hi,
I would like to ask, is there any way i could migrate data on my SQL Server
7 to SQL Server 2005? Is there any available white paper or article regardin
g
this? Kindly refer one to me.
Thanks in advance.In upgrading from SQL 7 to SQL Server 2005 you have the option to perform
- in place upgrade (replace existing SQL, which is not best practices).
- side / by side upgrade (install an instance of SQL 2005 next to or on
another server)
- transfer databases using backup / restore
- transfer databases using Copy Database Wizard in SQL 2005
- transfer databases using attach /detach
- transfer logins / user defined error message / jobs ..using Copy
Database wizard or SQL Integration Services
On transfering data you will find a lot of interesting info on
www.microsoft.com/learning/sql which provides you with free e-learning on
SSIS.
(formerly known as DTS)
Have a look at SQL Upgrade Advisor (www.microsoft.com/sql) for a nice tool
that will analyze your SQL 2005.
Read all documents in there for know issues and migration issues.
Dandy Weyn
[MCSE-MCSA-MCDBA-MCDST-MCT Community Leader]
SQL Server Technologist
http://www.dandyman.net
Check my SQL Server Resource Pages at http://www.dandyman.net/sql
"lonskie1030" <lonskie1030@.discussions.microsoft.com> wrote in message
news:AD96303E-204F-4816-9E12-7644BF75CD2D@.microsoft.com...
> Hi,
> I would like to ask, is there any way i could migrate data on my SQL
> Server
> 7 to SQL Server 2005? Is there any available white paper or article
> regarding
> this? Kindly refer one to me.
> Thanks in advance.
>|||Thanks for your response. I already saw one at MS Site. Anyway, thanks again
..
"Dandy Weyn [Dandyman]" wrote:

> In upgrading from SQL 7 to SQL Server 2005 you have the option to perform
> - in place upgrade (replace existing SQL, which is not best practices).
> - side / by side upgrade (install an instance of SQL 2005 next to or on
> another server)
> - transfer databases using backup / restore
> - transfer databases using Copy Database Wizard in SQL 2005
> - transfer databases using attach /detach
> - transfer logins / user defined error message / jobs ..using Copy
> Database wizard or SQL Integration Services
> On transfering data you will find a lot of interesting info on
> www.microsoft.com/learning/sql which provides you with free e-learning on
> SSIS.
> (formerly known as DTS)
> Have a look at SQL Upgrade Advisor (www.microsoft.com/sql) for a nice tool
> that will analyze your SQL 2005.
> Read all documents in there for know issues and migration issues.
>
> --
> Dandy Weyn
> [MCSE-MCSA-MCDBA-MCDST-MCT Community Leader]
> SQL Server Technologist
> http://www.dandyman.net
> Check my SQL Server Resource Pages at http://www.dandyman.net/sql
> "lonskie1030" <lonskie1030@.discussions.microsoft.com> wrote in message
> news:AD96303E-204F-4816-9E12-7644BF75CD2D@.microsoft.com...
>
>