Database migration from Sybase database to SQL Server 2005

We are going to be migrating an application and the first step is to
migration the Sybase database to SQL Server 2005 database. Can anyone shed
some light into this and help me understand the process involved? What are
the possible pitfalls? What should the approach be?
Thanks,
NewbieHi
I have never migrated from Sybase, but I would expect to treat it in a
similar way to migrating from SQL 6.5 to a higher version. If your code is
not already in Source Code control, then I you may want to make that a
pre-requisite for the migration. You should then be able to get to a stage
where you can build a SQL 2005 database from this code rather than use a
migration tool. When migrating the data you can use SSIS, although if you
require more control it may be worth considering using a two stage process
such as exporting the data into flat files and then importing it.
John
"NewToMigration" wrote:
> We are going to be migrating an application and the first step is to
> migration the Sybase database to SQL Server 2005 database. Can anyone shed
> some light into this and help me understand the process involved? What are
> the possible pitfalls? What should the approach be?
> Thanks,
> Newbie
>|||Thanks, John, for your response. I will make sure I keep this in mind.
Regards,
Newbie
John Bell wrote:
>Hi
>I have never migrated from Sybase, but I would expect to treat it in a
>similar way to migrating from SQL 6.5 to a higher version. If your code is
>not already in Source Code control, then I you may want to make that a
>pre-requisite for the migration. You should then be able to get to a stage
>where you can build a SQL 2005 database from this code rather than use a
>migration tool. When migrating the data you can use SSIS, although if you
>require more control it may be worth considering using a two stage process
>such as exporting the data into flat files and then importing it.
>John
>> We are going to be migrating an application and the first step is to
>> migration the Sybase database to SQL Server 2005 database. Can anyone shed
>[quoted text clipped - 3 lines]
>> Thanks,
>> Newbie
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200602/1|||Hi
I forgot to add...
You will need to make sure that you do a full regression test.
Therefore having the "old" system to compare against will be useful!
John
"NewToMigration via SQLMonster.com" wrote:
> Thanks, John, for your response. I will make sure I keep this in mind.
> Regards,
> Newbie
> John Bell wrote:
> >Hi
> >
> >I have never migrated from Sybase, but I would expect to treat it in a
> >similar way to migrating from SQL 6.5 to a higher version. If your code is
> >not already in Source Code control, then I you may want to make that a
> >pre-requisite for the migration. You should then be able to get to a stage
> >where you can build a SQL 2005 database from this code rather than use a
> >migration tool. When migrating the data you can use SSIS, although if you
> >require more control it may be worth considering using a two stage process
> >such as exporting the data into flat files and then importing it.
> >
> >John
> >
> >> We are going to be migrating an application and the first step is to
> >> migration the Sybase database to SQL Server 2005 database. Can anyone shed
> >[quoted text clipped - 3 lines]
> >> Thanks,
> >> Newbie
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200602/1
>sql