Sybase to SQL CE

[justin_willey]

hi, I am very much new to sybase... I just want to know is it possible to copy data and structure of Sybase Tables to SQL CE. I want to copy whole data and structure from my Sybase Db to SQL CE Db. if possible , can some one suggest me how it can be done.

I have searched lot on internet but can't find anything related to Sybase to SQL CE.

Thanks & Regards, Joyous Suhas

[justin_willey]

Can you be more explicit about which products you are asking about? Is your existing database Sybase SQLAnywhere or Sybase ASE - they are entirely different products, so the answers are likely to be different. Also which versions of each of the products? That information should enable you to get a helpful answer more quickly - or at least pointers in the right direction.

[Former Member]

We still use SQL Anywhere 5.5.4 with its ODBC-interface and we have to migrate to SQL CE. so i want to convert all databases to SQL CE with its structure and Data. Is it possible?

[justin_willey]

As Volker says in his answer - if you are looking to go from SQLA 5 to MS SQL Server Compact Edition, you will need to look at the migration tools Microsoft (or third parties) provide for accessing ODBC data.

From what I remember DTS doesn't include support for MS SQL Server CE, so you first convert to normal SQL Server and then use the SQL Server Express Edition Toolkit - help with that stage would probably be best found on an MS forum.

Conversion to SQL Server with DTS should be fairly straight forward, SQLA 5 will look like a normal ODBC data source with system tables etc.

[MarkCulp]

If you are using SQL Anywhere then all you need to do to copy your data from one platform to another is to copy the database... since SQL Anywhere databases are platform independent and can be easily copied from one computer to another by simply doing file copies.

If you are using one of the other Sybase datatabase products - IQ, ASE, ADS - then you will likely need to transfer your data from that product into SQL Anywhere since AFAIK these products don't have versions that run on CE. To copy your data you have a couple of solutions but the easiest may be to use Proxy Tables.

Another solution is to use Mobilink to sync the data from your current database to the SQL Anywhere or Ultralite database running on your CE device.