"Acheton" <acheton@hotmail.com> wrote in message
news:O04ATjsAFHA.2568@TK2MSFTNGP10.phx.gbl...
> Hi all,
>
> I'm a new user to SQL Server, hence the post here. I am trying to migrate
> a database from Sybase Adaptive Server Anywhere version 8.0.2 to SQL
> Server 2000 SP3. So far I have:
>
> Created a new database in SQL Server
> Created a new linked server, using ODBC, to the Sybase DB
> Copied all of the table definitions from Sybase to SQL Server using the
> Import/Export functionality or DTS
>
> However I cannot seem to get the foreign key relationships to migrate
> across to SQL Server, which is a bit of a pain since there any several
> hundred tables! Has anyone done this before or does anyone know how to do
> it? My fall back plan is to unload the database structure in Sybase, edit
> the SQL script which is generated so it is compatible with SQL Server and
> do things that way. Any ideas or advice would be much appreciated. Also is
> this the correct group to post in if I have some newbie questions about
> setting up replication on SQL Server?
>
> Thanks,
>
>
> Ach

Cristian Lefter wrote:
> Maybe this pages will suggest you a better approach:
> "Chapter 6 - Migrating Sybase Databases to SQL Server 2000"
> http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0661.mspx
> "Migrating from Sybase to SQL Server "
> http://www.devarticles.com/c/a/SQL-Server/Migrating-from-Sybase-to-SQL-Server/