MS SQL CE 3.0/3.1 with MS SQL Server 2008

Question

hello everybody

 

i upgraded my SQL Server 2005 to SQL Server 2008, but i still need to use SQL CE 3.0 / 3.1 Databases.

How can i create and sync SQL CE 3.0 / 3.1 databases with SQL Server 2008 ?

Can i do this with SQL Server 2008 Management Studio too ?

 

Thanks for reply

Best Regards

Answer 1

Yes, you can sync 3.0/3.1 databases with 2008 - see this http://blogs.msdn.com/b/sqlservercompact/archive/2007/12/19/connectivity-cross-version-compatibility-sql-server-compact-3-5.aspx section 2.1.2

No, SQL Server 2008 Management Studio can only connect to SQL Server 3.5 files. You can use SQL Server 2005 Management Studio Express SP2 instead.

---

http://erikej.blogspot.com Erik Ejlskov Jensen - Please mark as answer, if this was it.

Answer 2

hoi erik

 

thanks for your reply!

 

But how can i sync my Databases by using Sql Server 2005 Management Studio and Sql Server 2008 ?

I get i error (Sql Server 2005 Management Studio can only used with Sql Server 2000 / 2005) when i try to connect from Sql Server 2005 Management Studio to Sql Server 2008!

How can i access my created Sql Server 2008 DB-Replication and get sync the 3.0/3.1 databases by using Sql Server 2005 Management Studio ?

 

Thanks again

Cheers

Answer 3

When do you get the error - from the New Subscription Wizard in SSMS 2005?

---

http://erikej.blogspot.com Erik Ejlskov Jensen - Please mark as answer, if this was it.

Answer 4

Hoi Erik,

 

Yes, you are right!

 

That's what i did:

1. Open SSMS 2005

2. Connect to my Sql Ce 3.1 Database

3. Add new Subscription

4. Choose Publisher

5. Search sql publisher

6. Connect to SqlServer 2008 Database <--- Error occurs here!!!

 

Do you have any idea ?

 

Thanks a lot again!

Answer 5

I think this scenario is not supported - you will have to write code to test the sync.

---

http://erikej.blogspot.com Erik Ejlskov Jensen - Please mark as answer, if this was it.

Answer 6

i got it :-)

 

to solve this problem

i did the following steps:

1. Install MS Sql Server 2005 SP 2

2. Install MS Sql Server 2005 SP 2 Cumulative Hotfix 2315

3. Reboot

4. Try again...

 

That's it!

 

 

 

Answer 7

hoi erik

 

there is still a problem :-(

i can access now the SS2008 from SSMS2005 but when i click <finish> to finish the assistent of New Subcription, i got the following error:

------------------------------

IIS error 404 HTTP_STATUS_NOT_FOUND: The server has not found anything matching the requested URI (Uniform Resource Identifier).

HRESULT 0x80004005 (28016)
------------------------------

 

i was not sure about the SSMS2005 support of SS2008,

so i wrote a small program that implement the SqlCeReplication.Syncronize method.

but i get the same exception when it calls the Syncronize() method.

 

do you have any idea why ?

thanks a lot.

Answer 8

Could be a problem in your agent URL - could you show us what it is?

---

http://erikej.blogspot.com Erik Ejlskov Jensen - Please mark as answer, if this was it.

Answer 9

i've tried to access the full url in my webbrowser and i got also a 404 exception.

i could solve it!

the iis need to be config at the IASPI and GCI Extensions area to allow executing the sqlcesa30.dll.

but now i'm turning into the next problem:

==> The server agent could not connect to the publisher. HRESULT 0x80070057 (29049)

i was googling for this message and the following link says i need to uninstall one of my SSCE-tools, but at my machine there is only one SSCE-tools version (SSCE 3.5 SP2 x64)

http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/950bbf19-384f-4177-94a0-0e088cd4ffae

any ideas ?

thanks again!

Answer 10

What is the result of http://myhost/myvdir/sqlcesa35.dll?diag

---

http://erikej.blogspot.com Erik Ejlskov Jensen - Please mark as answer, if this was it.

Answer 11

hoi erik

 

at the end it was not possible for me to subcribe the SS2008 publication from SSMS2005.

i don't know why, i still got the same error like above!

 

i have written a sync app and it's working fine for me.

 

thanks for your help

Answer 12

UPDATE:

Install Microsoft SQL Server Compact 3.5 SP2 for Server Tools
and Service Pack 4 (SP4) for Microsoft SQL Server 2005 ( http://www.microsoft.com/downloads/en/details.aspx?FamilyID=b953e84f-9307-405e-bceb-47bd345baece )

and it works :-)

hth

Answer 13

Please can you say to me how did you solve the 404 exception.

Please reply to me as soon as possible

Thanks