Change MS Access to SQL Server Compact

[arusoft]

Currently we are using MS Access as portable database. We use TuniConnection to connect to it. Is there easy way to change from MS Access to SQL Server compact database?

Thanks.

[AndreyZ]

UniDAC supports SQL Server Compact Edition. To connect to SQL Server Compact database, you can use the following code:

Code: Select all

UniConnection.ProviderName := 'SQL Server';
UniConnection.Database := 'filename'; // .sdf
UniConnection.SpecificOptions.Values['OLEDBProvider'] := 'prCompact';
UniConnection.LoginPrompt := False;
UniConnection.Open;

Migrating from MS Access to SQL Server Compact is out of scope of our support. You can take a look at the following topic: http://social.msdn.microsoft.com/Forums ... rom-access . For more information, please write to the Microsoft support.