Sample Header Ad - 728x90

Can you Mirror an Microsoft SQL compact Edition database

0 votes
1 answer
139 views
We have a PLC inputting summary data into a Microsoft Compact SQlce Edition database. We would like to run queries to on this data, but are unable due to the type of database it is, compact. It, as far as I understand, exposes nothing to the network so we're unable to connect with ODBC connection, or anything of that sort. The company that put it in suggested a database mirror to an existing SQL server database we already have. Which seems plausible except for the extra overhead, which might cause some latency issues. Is it possible to Do a database mirror with the SQLce as the principle database? I have seen nothing on-line that makes me think this can be done, in fact I've seen hints that it can't. I am not set on Database mirror we just need a way to get the information off this device.
Asked by Sam Orozco (103 rep)
Aug 19, 2016, 03:13 PM
Last activity: Aug 20, 2016, 02:46 PM