Overview Of ‘Microsoft SQL Server Compact 3.5 Sp2 Enu’ & Its Features

Asked By 0 points N/A Posted on -

Hello guys, I am learning basics of database management and my friend has recommended me to try my hand on Microsoft SQL server compact 3.5 sp2 enu for better understanding. But I want an overview about it and want to know about its various new features which were not embedded in previous versions.

Answered By 10 points N/A #298267

Overview Of ‘Microsoft SQL Server Compact 3.5 Sp2 Enu’ & Its Features


SQL Server Compact 3.5 SP2 is an inserted database that permits designers to assemble powerful applications for Windows desktops and cell phones. The program contains the documents for introducing SQL Server Compact 3.5 SP2 on Windows desktop.

The most well-known discharge is 3.5.8080.0, with more than 98% of all establishments presently utilizing this adaptation. The essential executable is named ConnWiz.exe. The setup bundle for the most part introduces around 89 records and is for the most part around 4.84 MB (5,072,244 bytes).

SQL Server Compact 3.5 SP2 incorporates the accompanying new elements:

  • It bolsters working with a SQL Server Compact 3.5 database when you utilize the Transact-SQL Editor in Visual Studio 2010. The Transact-SQL Editor can be utilized to run free-content Transact-SQL inquiries against a SQL Server Compact 3.5 database. The Transact-SQL Editor additionally gives you a chance to view and spare Nitti gritty evaluated and real inquiry indicate plans for SQL Server Compact 3.5 databases. Beforehand, the usefulness that is given by the Transact-SQL Editor was accessible just through SQL Server Management Studio.
  • It is easier to understand than the past variants. New classes and individuals that are named SqlCeChangeTracking are added to the System.Data.SqlServerCe namespace to uncover the inner change following element that is utilized by Sync Framework for tracking the modifications in the database. The SQL Server Compact change following foundation keeps up data about supplements, erases, and overhauls that are performed on a table that is empowered for change following. This data is put away both in segments that are added to the followed table and in framework tables that are kept up by the following foundation. By utilizing System.Data.SqlServerCe.SqlCeChangeTracking, you can design, empower, and handicap change following on a table. You can likewise get to the following information that is kept up for a table. The API can be utilized to give usefulness in numerous situations. For instance, the API can be utilized to give custom executions of customer -to-server or customer-to-customer match up for once in awhile associated frameworks (OCS) or to actualize a custom audience application.
  • The oversaw congregations of SQL Server Compact are used by the various applications that secretly send SQL Server Compact are introduced in the accompanying organizer:

%Program Files%\Microsoft SQL Server Compact Edition\v3.5\Private

On the off chance that you will utilize these gatherings then the application makes a point to utilize the secretly conveyed form of Compact notwithstanding when a prior rendition of SQL Server Compact 3.5 is introduced in the GAC.

  • Visual Studio 2010 introduces both the 32-bit and 64-bit variants of SQL Server Compact 3.5 SP2. If a SQL Server Compact application is deployed by utilizing Click Once in Visual Studio 2010, both the 32-bit and the 64-bit adaptation of SQL Server Compact are introduced on a 64-bit PC.
  • SQL Server Compact 3.5 SP2 underpins Windows 7 and Windows Server 2008 R2 and can synchronize information by utilizing combine replication with SQL Server 2008 R2.

Login/Register to Answer

Related Questions