how to synchronize between sql mobile 2005 & sql 2000?

Hi, I need to synchronize a sql mobile database & sql 2000 database.

Someone knows how can I export a SQL 2000 db to SQL mobile 2005 (.sdf)?

Cesar!

Please see topic "Managing Connectivity (SQL Server Mobile)" at http://msdn2.microsoft.com/en-us/library/ms171801(en-US,SQL.90).aspx.

|||Do note that Merge Replication does not support SQL 2000 publisher and SQL 2005 subscriber.
|||

Thk Greg, but do u mean what can not I use SQL 2000 & SQL 2005 mobile?

look, I did each step for synchronization, and I wrote this code in vbnet 2005,

Dim repl As New SqlCeReplication

try

repl.interneturl=http://localhost/myproject/sqlcesa30.dll

....

repl.AddSubscription (AddOption.ExistingDatabase)

repl.Sybchronize() ' here I got an error

Catch ex As Exception

..

end try

the message is : "An error hac ocurred on the computer running IIS. Try restarting the IIS Server"

I did it, but the same error continue

do u know what i need to do?

Thank in advanced

Cesar

|||

Cesar Burbano wrote:

repl.Sybchronize() ' here I got an error

For one, it looks like you have a typo in the word "Synchronize".

|||

Yeah, I wrote it bad here (forum), but in the code is Ok, I couldnt copy it from the code

I got the same error when I tried to use SqlCeRemoteDataAccess.

I can not to synchronize it, yet

Cesar