Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Merge Replication via HTTP SQL and MSDE

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-03-05 : 07:48:17
Georg writes "We are planning a distributed offline solution using SQL Server as central database and MSDE as client databases. We plan to use merge replication via internet. An aditional option for total offline transport via file transfer would be great. I have two questions:

1. Is there any way to use http/ssl transport across normal firewalls as possible with replication against SQL CE? I did not found anything about that. ODBC and FTP or VPN transport as documented is impractical because of the common firewall restrictions.

2. In your documentation is mentioned that any schema modification made by SQLScript is not replicated. Your advice is to make schema modifications with interactive tools. But this is completely impossible for delivering schema modifications to several customers. What is your solution in this case?"
   

- Advertisement -