Database Problem ??

[Guest]

How to download the database From SQL Server 2000 or 7 to SQL Server CE. Can This work on emulator ??? Where should I put the code to download the database ?? Is it in "Form_Load
Thanks

 

[William Ryan eMVP]

A Sql Server 2000 or 97 DB isn't going to work on CE. Different file types,
different everything. You'll need to set up Replication
http://samples.gotdotnet.com/quickstart/CompactFramework/doc/sqlcemergereplication.aspx

The main thing is going to be calling the Synchronize method of your
SqlCeReplication object. You can do this in form_load, when the application
starts, when it ends, wherever it's appropriate in your app.

HTH,

Bill

How to download the database From SQL Server 2000 or 7 to SQL Server CE.

Can This work on emulator ??? Where should I put the code to download the
database ?? Is it in "Form_Load"

 

[Guest]

I try to install sqlce20sql2ksp1 that come with VS.NET 2003 but it display error message – “SQL Server CE Server Tool is compatible only with SQL Server 2000 Service Pack 1 and higher. When you install SQL Server CE Tools on a computer running both IIS and SQL Server 2000, ensure the installer for SQL Server CE Server Tools corresponds to the version of SQL Server 2000.

Then I download “SQL Server 2000 – service pack 3†and install but it still show above error message. Why ??? If I not mistaken, I need to install SQL Server service pack 1 first, follow by service pack 2 and service pack 3.

Each version of service pack has three installer for instance: SQL2KASP1, SQL2KDeskSP1, and SQL2KSP1. Do I need to install all of them in order to install SQL Server CE.

How to know that the service pack successfully install ??? Can I check it ?