Hi,

Is there any way that an existing database in SQL Express can be converted to a SQL Anywhere ?

regards

You can use the SQL Server Integration Services to move the data from SQL Express to SQL Server Everywhere. The links from the Online MSDN is as given below:

http://msdn2.microsoft.com/en-us/ms140269.aspx

http://msdn2.microsoft.com/en-us/ms141093(SQL.90).aspx

Thanks

Ambrish

Hello Ambrish

Thanks for a quick response.

But honestly, didn't understand how to do it.

I have created a database using SQL Express 2005 and have a project (using VB 2005 Prof) fully working with this db. Since the release of SQL Everywhere, want to try out the same project by just creating / porting the sql express database to sql everywhere (both structure as well as data - atleast the structure)

regards

Dharam

Hi Dharam,

SSIS transfers data table by table from a data source to SQL Mobile database. It does not transfer the schema. There are third party tools that transfers schema and data.

João Paulo Figueira has provided a link to a tool in the following post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=484575&SiteID=1

Regards

Ambrish