Is IIS always required for replication?

I would like to take advantage of either Merge or RDA replication over HTTP, but would like to avoid setting up IIS.

Is IIS always required to support connectivity for SQL Server Mobile replication back to a desktop SQL Server database?

Thanks, Tim

Yes IIS is very much required for Merge or RDA with SQL Server. However, setting up IIS is not a big thing as we have a "Configure Web Synchronization" wizard that is very helpful for you in this regard.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||Hi

And how setting up a replication bettween a Windows Mobile 5 Pocket PC and a Windows XP Home Edition PC when IIS can't be install on Home Edition ?

?

Thanks for help
Jo?l

|||

1) What is your backend database?

2) Can I know what is the problem in moving to Win XP Professional Edition?

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||1) To replace synchronisation between Access/PocketAccess (not more supported with WM5), we use know a MSDE database (on PC) with a SQL Server CE 2.0 database (on PocketPC). The replication work fine on Windows XP Pro, but on Windows XP Home there is no IIS to do the replication.

2) Our customer have Windows XP Home Edition. I'm ok with you that's not very "professional", but we can't tell to our customer : "Hey guys, you must move your forty PC to Windows XP Pro, because our software don't run on XP Home". They will say us "bye bye".

And they have already some old PocketPC (before WM5) with this application installed and it works with XP Home ... that's a big problem for us.

Thanks for helping us

|||I have heard that we can synchronize using ActiveSync is it correct or not, because on Online Book I read we can synchronize using IIS. I need to synchronize my database on Pocket PC to my Desktop PC without using IIS (if we have the cradle why we need access to internet from Pocket PC).

And if synchronized only can work with IIS than use the old way try to send each data by client server application. Its a silly things, but thats the only way if we can only synchronize using IIS.

Is IIS always required for replication?

I would like to take advantage of either Merge or RDA replication over HTTP, but would like to avoid setting up IIS.

Is IIS always required to support connectivity for SQL Server Mobile replication back to a desktop SQL Server database?

Thanks, Tim

Yes IIS is very much required for Merge or RDA with SQL Server. However, setting up IIS is not a big thing as we have a "Configure Web Synchronization" wizard that is very helpful for you in this regard.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||Hi

And how setting up a replication bettween a Windows Mobile 5 Pocket PC and a Windows XP Home Edition PC when IIS can't be install on Home Edition ?

?

Thanks for help
Jo?l|||

1) What is your backend database?

2) Can I know what is the problem in moving to Win XP Professional Edition?

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||1) To replace synchronisation between Access/PocketAccess (not more supported with WM5), we use know a MSDE database (on PC) with a SQL Server CE 2.0 database (on PocketPC). The replication work fine on Windows XP Pro, but on Windows XP Home there is no IIS to do the replication.

2) Our customer have Windows XP Home Edition. I'm ok with you that's not very "professional", but we can't tell to our customer : "Hey guys, you must move your forty PC to Windows XP Pro, because our software don't run on XP Home". They will say us "bye bye".

And they have already some old PocketPC (before WM5) with this application installed and it works with XP Home ... that's a big problem for us.

Thanks for helping us|||I have heard that we can synchronize using ActiveSync is it correct or not, because on Online Book I read we can synchronize using IIS. I need to synchronize my database on Pocket PC to my Desktop PC without using IIS (if we have the cradle why we need access to internet from Pocket PC).

And if synchronized only can work with IIS than use the old way try to send each data by client server application. Its a silly things, but thats the only way if we can only synchronize using IIS.

Is DTC required in a SQL 2000/Windows 2003 cluster ?

Hi,
If the SQL environment is not going to use distributed transactions, is it
still necessary to configure a DTC resource on the cluster ?
Thanks
In theory, you can run SQL 2000 clustered without DTC. In practice, it can
limit functionality. I generally configure a DTC resource, just to simplify
installation and maintenance.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"SteveO" <SteveO@.discussions.microsoft.com> wrote in message
news:332351AB-0806-4F9A-94DF-C5F929F5B7D0@.microsoft.com...
> Hi,
> If the SQL environment is not going to use distributed transactions, is it
> still necessary to configure a DTC resource on the cluster ?
> Thanks
|||Yes. You will always configured DTC into the cluster. There are other
services which will use it.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"SteveO" <SteveO@.discussions.microsoft.com> wrote in message
news:332351AB-0806-4F9A-94DF-C5F929F5B7D0@.microsoft.com...
> Hi,
> If the SQL environment is not going to use distributed transactions, is it
> still necessary to configure a DTC resource on the cluster ?
> Thanks
|||I hate to nitpick. But technically, you don't have to if you don't need it.
Linchi
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:%23YUT2d2IGHA.2912@.tk2msftngp13.phx.gbl...
> Yes. You will always configured DTC into the cluster. There are other
> services which will use it.
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
> "SteveO" <SteveO@.discussions.microsoft.com> wrote in message
> news:332351AB-0806-4F9A-94DF-C5F929F5B7D0@.microsoft.com...
>
|||Well, you'd have to take that up with the failover clustering team. It is
their explicit recommendation for ALL clusters that you will install a
failover cluster instance in.
Not having it there is going to cause several errors during the upgrade as
well as throwing additional errors during a fresh install. I haven't tested
enough permutations to say whether it is needed or not, so at this point, I
tend to trust the people who have spent thousands of hours testing hundreds
of different configurations. They know the code a lot better than me since
they wrote it. If that's the recommendation, I'm sticking into in this
case, because I have no way of proving that it shouldn't be followed.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Linchi Shea" <linchi_shea@.NOSPAMml.om> wrote in message
news:%23Dc$G%238IGHA.2064@.TK2MSFTNGP09.phx.gbl...
>I hate to nitpick. But technically, you don't have to if you don't need it.
> Linchi
> "Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
> news:%23YUT2d2IGHA.2912@.tk2msftngp13.phx.gbl...
>
|||I have 15 SQL Clusters in Production without MSDTC in the cluster, the local
service is disabled. No issues. Our application simply does not use it!
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:uuCH0K9IGHA.1132@.TK2MSFTNGP10.phx.gbl...
> Well, you'd have to take that up with the failover clustering team. It is
> their explicit recommendation for ALL clusters that you will install a
> failover cluster instance in.
> Not having it there is going to cause several errors during the upgrade as
> well as throwing additional errors during a fresh install. I haven't
> tested enough permutations to say whether it is needed or not, so at this
> point, I tend to trust the people who have spent thousands of hours
> testing hundreds of different configurations. They know the code a lot
> better than me since they wrote it. If that's the recommendation, I'm
> sticking into in this case, because I have no way of proving that it
> shouldn't be followed.
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
>
> "Linchi Shea" <linchi_shea@.NOSPAMml.om> wrote in message
> news:%23Dc$G%238IGHA.2064@.TK2MSFTNGP09.phx.gbl...
>
>

Is Conversion from SQL Server Express to Full SQL Server Required?

If I develop my app in SQL Server 2005 Express, and then want to use a hosting service that only offers full SQL Server 2005, do I have to do some kind of conversion to my DB file, and if so, what might that be? (I notice that there are hosting services that provide SQL Server Express...I'd like to know how much work it would be to be able to use other services.)

Any guidance on this would be appreciated.

Thanks!

it is an easy process to upgrade the database... you have two methods that you can use. the first is to use the detatch/attach method... with this you would just detatch the database on you server and then have the hosting company attach it for you. Or you could just use the backup restore method.... This is the way I would go.

|||In case that your hosting company isn′t that friendly to attach the database for you nor will let you know where you can put your backup files on to restore it from that media (like my hosting company isn′t doing for me :-) ) you can use the Database Import Wizard (which works in my case because my hosting company offers port 1433 to the internet for the server) and create a SSIS package to do the job.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

Glenn, thanks for the input.

I'm assuming in the scenario you describe that I would upload the mdf and ldf files to "my" directory on the hosted service systems, and then the operations you suggest would be performed from there...is that correct?

|||

Jens, thanks for the input.

In the scenario you describe, would I upload my DB to the hosted service first, and then operate the Database Import Wizard? Or is there another set of file moves involved? (Kind of piecing this together from newbie space :-)

|||No, actually not. As I don′t know which server is hostingn my SQLServer database on the hosting server. Even if I would upload my database I would not know the paths to attach the database. I use the DTS Import / Export wizard over the internet, directly importing the data into the "Internet" database.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||I would assume you have a "db" folder or "database" folder that you have access to on your hosted web server and, if so, that's where they'll likely go. Talk to your webhost and ask their advice since they'll be the ones working with you on it.|||

Thanks for input. I appreciate that I'll need more detail and coordination with the hoster; this thread has been useful in providing me with orientation on the basic mechanics.

Grazie!