Forum Discussion

rpwelton's avatar
12 years ago

Support for SQL Compact?

I'm testing a WPF application that is built on top of a SQL Compact database.  SQL Compact seems to be a relatively obscure format that's not supported by a lot of applications, but basically it's a Microsoft SQL Server product, however instead of the data existing in an instance like SQL Express or SQL Server, each database stores all of its data in a single file (sdf file) which can be easily shared amongst users or distributed (downloaded) via a web service.  It's primarily used for mobile devices due to its small footprint, but this application is a desktop app, not mobile.



I didn't see it listed in the list of service providers for TestComplete.  I tried SQL Server OLE DB but it makes me choose a server, which doesn't apply in this case because SQL Compact operates off of local files, not a server.

2 Replies