Help w/SQL Mobile to SQL Compact Edition

Hello

We currently use SQL Mobile and SQL Server 2005. We depend heavily on merge replication for data to the field handheld devices.

We are going to be starting some new projects and I was wondering about moving to SQL Compact Edition as the first step to migrating all of our applications.

I am concerned, however, about the server side and replication. If we simply deploy SQL Compact Edition will there need to be any changes to the server for replication?

Thanks,

- will

Yes, that should be the case. SQL CE is basiclay just a newer version of SQL Mobile.

|||

Are you saying that there isn't anything on the server that I need to do...or that I will need to install and test the newer versions of the server tools?

|||The server tools have been update slightly, so you should use these. Download from: http://www.microsoft.com/downloads/details.aspx?FamilyID=4e45f676-e69a-4f7f-a016-c1585acf4310&displaylang=en

Help w/SQL Mobile to SQL Compact Edition

Hello

We currently use SQL Mobile and SQL Server 2005. We depend heavily on merge replication for data to the field handheld devices.

We are going to be starting some new projects and I was wondering about moving to SQL Compact Edition as the first step to migrating all of our applications.

I am concerned, however, about the server side and replication. If we simply deploy SQL Compact Edition will there need to be any changes to the server for replication?

Thanks,

- will

Yes, that should be the case. SQL CE is basiclay just a newer version of SQL Mobile.

|||

Are you saying that there isn't anything on the server that I need to do...or that I will need to install and test the newer versions of the server tools?

|||The server tools have been update slightly, so you should use these. Download from: http://www.microsoft.com/downloads/details.aspx?FamilyID=4e45f676-e69a-4f7f-a016-c1585acf4310&displaylang=en

Help setting up replication on remote IIS

Hello,

I am trying to setup merge replication for a sqlmobile database. I was able to set it up on a test environment which the sql instance and the iis were on the same box. I am trying now to go live. Our sql instance is on another box than the iis. I am now getting a 404 error when trying to test in the url https://www.domain.com/sqlmobile/sqlcesa30.dll?diag Is there a walk through for iis running on a different box, or does someone know of a solution?

HTTP Error 404 - File or directory not found.
Internet Information Services (IIS)

Hi John
questions:
-what do you understand under a "box"?
-can you open the https://www.domain.com/sqlmobile/sqlcesa30.dll?diag site on the server where you are running the IIS? with the ipAdress of the server instead of the www.domain.com
-if so, can you access it from another computer in the network?
you can't synchronize until you can find this dialog from your mobile browser.
-have you updatet the Client Agent (sqlcesa30.dll) with the WebSynchronisation Wizard accordning to the new configuration?

- as you probably know, you are connecting with the anonymous user IUSR_servername of the SQL Server from the mobile device to the webserver, so on the IIS-Server you have to know this user an give him the needed accessrights

It seems to me that there is a problem with the configuration or the access rights

Greets Florian
|||

there are only two big "gotchas" with setting up replication with a separate IIS and SQL Server machine.

1. the account you plan to use that will provide credentials between the ISAPI dll (sqcesa30.dll) and the distributor must be known to both machines. If you were using the IIS Anonymous user's credentials (IUSR_{your machine name}), this will no longer work, because the distributor has no knowledge of this account when running on a separate machine. if both machines are on a domain, instead of IUSR_, use a domain account that it known to both IIS and SQL Server machines and grant it permissions on the IIS Virtual Directory, the publication, and the published articles themselves.

2. you must install the SQL Mobile server tools on both the IIS and SQL Server machine. use the SQL Server 2005 setup disc on the IIS machine, do a custom install, and select only the server tools for SQL Mobile.

Darren

Help setting up Peer-to-peer replication for approximately 500 db'

We are looking for a script that will setup Peer-to-peer replication for
approximately 500 databases.
Obviously the Wizard will do it, but it would be extremely time consuming.
And, after setting up the publication you would still have to setup the
Peer-to-Peer topology.
Is there a simple way script the entire process?
peer-to-peer is only really scalable to 10 or so nodes.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Jarek Gal" <Jarek Gal@.discussions.microsoft.com> wrote in message
news:916ACC30-728E-4AA6-9D7D-0CDA7DD50407@.microsoft.com...
> We are looking for a script that will setup Peer-to-peer replication for
> approximately 500 databases.
> Obviously the Wizard will do it, but it would be extremely time consuming.
> And, after setting up the publication you would still have to setup the
> Peer-to-Peer topology.
> Is there a simple way script the entire process?
|||We have 2 SQL servers but need to do that 500 times. So the 10 nodes is not
an issue.
"Hilary Cotter" wrote:

> peer-to-peer is only really scalable to 10 or so nodes.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Jarek Gal" <Jarek Gal@.discussions.microsoft.com> wrote in message
> news:916ACC30-728E-4AA6-9D7D-0CDA7DD50407@.microsoft.com...
>
>
|||Once you've set it up for one node, scripting it out and amending the
scripts for each subsequent node shouldn't be too difficult:
http://www.replicationanswers.com/Script3.asp. You'll still need to get the
backup files restored on each node before commencing though.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .