Data encryption whilst synchronising
jbaggaley Posts: 38
edited March 30, 2006 8:39AM in SQL Toolkit Previous Versions
I am about to write an application for our sales reps to remotely synchronise their laptop data with the master database over the web. Because their data contains financial details, I would ideally like to try and make sure that the data transmitted during the synchronisation process is encrypted to prevent easy interception. Does anyone have any good suggestions for how this can be accomplished using the toolkit or is it something that should be done using technologies like HTTPS? Also, will the toolkit work over the web using a secure connection or do I need to consider an alternative strategy for synchronisation?
0 · Share on Twitter
I can answer the web part. None of the Toolkit can really be used with Web Services beause the objects aren't serializable for the most part. For instance, you couldn't develop a webservice that returns a populated RedGate.SQLCompare.Database object over the Internet.
If you wanted to actually run a data script over the Internet, you could create an alias using encryption and enable the SQL Server encrypted protocol over the network in the server network utility. You could also simply ensure you have a VPN connection between the application and the server, which would also encrypt any data coming across.