Microsoft SQL Server CE Connection

SQL Server Compact Edition contains the run-time bits that can be used to develop applications and to deploy applications on desktop computers and on Tablet PCs. SQL Server Compact Edition is a powerful yet lightweight relational database engine. SQL Server Compact Edition supports familiar SQL syntax. Additionally, SQL Server Compact Edition provides a development model and an API that are consistent with SQL Server. Therefore, you can more easily develop desktop applications by using the RTW version of SQL Server Compact Edition than by using SQL Server Mobile. SQL Server Compact Edition includes new features such as |DataDirectory| substitution string support and ClickOnce support so that deployment is easy.

To create a SQL Server Compact Edition connection, follow these steps:

  • In the Name Text Box type in a new name for the SQL Server Compact Edition connection you are about to create
  • Select Database name
  • Click OK to close the connection properties window

Download Microsoft SQL Server Compact 4.0

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL Forum

  • aetle/connections/database/sql_server_ce.txt
  • Last modified: 10/06/2015 05:04
  • by admin