"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.
>

"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...
> > 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.
> >
>
>