The information found in the is not very extensive, and this blog post hopes to extend on the information found there. I have already private deployment with SQL Server Compact 4.0, and have an overview SQL Server Compact 3.5 SP2 requires the following software: The OS must be Windows XP SP3 or higher: For applications targeting.NET 3.5 SP1, no additional software is required. For applications targeting.NET 4.0, either.NET Framework 3.5 SP1 or the VC 2005 SP1 redistributable (for x86 and/or x64) is required.
Make sure the 3.5 SP2 runtime is properly installed, on x64 machines you must install both the x86 and x64 runtimes. Let us assume that the requirements above are fulfilled (notice that Windows 7 includes.NET 3.5 SP1). So what else is required – let’s make a Console app and find out! Our goal is to create an application, that runs without SQL Server Compact 3.5 SP2 already installed, on both x64 and x86 systems.
Microsoft SQL Server Compact 3.5 SP1 Query Tools English A guide to uninstall Microsoft SQL Server Compact 3.5 SP1 Query Tools English from your PC Microsoft SQL Server Compact 3.5 SP1 Query Tools English is a software application. This page is comprised of details on how to uninstall it from your computer. It is made by Microsoft Corporation.
In Visual Studio, create a new Console project: Now we must include the unmanaged SQL Server Compact C runtime files, each set of files in their own folder, which are platform specific. So create 2 folders in the project, one named x86 for the 32 bit files, and one named AMD64 (not x64!) for the 64 bit files. NOTE: This convention, based on the value of the PROCESSORARCHITECTURE environment variable is a special. Now we must locate the required files.
If you are using a 32 bit machine, only the 32 bit files are installed on your machine, and you must manually extract the 64 bit files to a folder as. I am using (like most these days) a x64 machine, and it has the most recent files for both platforms already installed.
There are few downloads released for Microsoft SQL Server Compact 3.5. Here is quick lists of the same.
SQL Server Compact 3.5 SP2 is an embedded database that allows developers to build robust applications for Windows desktops and mobile devices. The download contains the files for installing SQL Server Compact 3.5 SP2 and Synchronization Services for ADO.NET version 1.0 SP1 on Windows desktop.
SQL Server Compact 3.5 SP2 Server Tools Windows Installer (MSI) file installs replication components on the computer running the Internet Information Services (IIS) for synchronizing data with SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2 November CTP. SQL Server Compact 3.5 is a small footprint in-process database engine that allows developers to build robust applications for Windows Desktops and Mobile Devices. This download contains the Books Online for the SP2 version of SQL Server Compact 3.5. Note: The brief description below the download link is taken from respective download page. Reference: Pinal Dave ( ).
Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 11 SQL Server database books, 21 Pluralsight courses and has written over 4500 articles on the database technology on his blog at a Along with 16+ years of hands on experience he holds a Masters of Science degree and a number of database certifications. For any send email at [email protected]. Pinal is also a. Nupur Dave is a social media enthusiast and an independent consultant.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |