Convert SqlExpress to Sql 2000

Some thread searches here say conversion (downgrade) of a SqlExpress database to Sql Server 2000 is trivial. I haven't yet figured out an efficient way of doing so beyond using someone's Database Publishing Wizard utility (http://www.codeplex.com/sqlhost) to create a sql 2000 compatible script, replete with schema *and* data, then running that script against the Sql 2000 database (freshly created without any structure). I've done this successfully with smaller databases, but the larger ones really tax and drain the server resources and scripts have failed with "out of memory" errors. We're putting more memory in the Sql 2000 server, which may avert memory errors, but there's still the issue of server load. Has anybody since come up with or know of a better method that's quicker, more efficent and less drain on the server?

TIA,

Rick
Nevermind. Was able to use 2000's DTS in conjunction with Database Publishing wizard. Much faster and easier on the server than INSERT scripts.

Convert SqlExpress to Sql 2000

Some thread searches here say conversion (downgrade) of a SqlExpress database to Sql Server 2000 is trivial. I haven't yet figured out an efficient way of doing so beyond using someone's Database Publishing Wizard utility (http://www.codeplex.com/sqlhost) to create a sql 2000 compatible script, replete with schema *and* data, then running that script against the Sql 2000 database (freshly created without any structure). I've done this successfully with smaller databases, but the larger ones really tax and drain the server resources and scripts have failed with "out of memory" errors. We're putting more memory in the Sql 2000 server, which may avert memory errors, but there's still the issue of server load. Has anybody since come up with or know of a better method that's quicker, more efficent and less drain on the server?

TIA,

Rick
Nevermind. Was able to use 2000's DTS in conjunction with Database Publishing wizard. Much faster and easier on the server than INSERT scripts.

Convert SQLExpress db to Sql Anywhere

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

Convert SQLExpress db to Sql Anywhere

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