CompactDatabase 方法回收本地 SQL Server 2005 Compact Edition (SQL Server Compact Edition) 数据库中的浪费空间。该方法还用于更改数据库的排序顺序、加密和密码设置。 语法 复制 object.CompactDatabase(SourceConnection, DestConnection) 参
How to: Create a SQL Server Compact Database on a Server How to: Create a SQL Server Compact 3.5 Database on a Connected Device How to: Maintain a Database (SQL Server Management Studio) How to: View the Execution Plan for a SQL Server Compact Query ...
Using SQL Server Compact (Visual Studio) SQL Server Compact 4.0 and Visual Studio How to: Add a SQL Server Compact Database to a Project How to: Deploy a SQL Server Compact 4.0 Database with an Application Walkthrough: Creating a SQL Server Compact Database Walkthrough: Adding a SQL Server...
SQL Server Compact 3.5SQL Server Compact 3.5 is a compact yet powerful embedded database for enabling users with a new generation of occasionally connected dynamic applications. Free, lightweight and embeddable, SQL Server Compact 3.5 offers essential relational database functionality to build a new ...
如需詳細資訊,請參閱<Database Engine 概觀 (SQL Server Compact Edition)>。 多使用者支援 為支援多個應用程式同時存取相同資料庫,SQL Server Compact Edition 提供資料頁的資料列層級鎖定、頁層級鎖定以及隔離層級,以協助確保並行期間的資料完整性。如需鎖定的詳細資訊,請參閱<鎖定(SQL Server Compact Edition)>與...
COMPACT; 1. 2. 3. 数据库迁移 如果以上方法无法解决问题,可以考虑将数据迁移到其他数据库引擎中,如SQL Server Express或者SQLite等。这样可以利用更大的存储空间来存储数据。以下是一个简单的迁移示例: INSERTINTONewDatabase.dbo.YourTableSELECT*FROMOldDatabase.dbo.YourTable; ...
SQL Server Compact 3.5–based applications can be developed for desktop computers by using Visual Basic 2008 Express Edition and Visual C# 2008 Express Edition. You can administer a SQL Server Compact database stored on a smart device or on a desktop computer by using SQL Server Management Studio...
Microsoft SQL Server Compact 4.0 is a free, embedded database that software developers can use for building ASP.NET websites and Windows desktop applications. SQL Server Compact 4.0 has a small footprint and supports private deployment of its binaries within the application folder, easy application...
对于SQL Server Compact Edition (SQL CE 3.1) 数据库,第一种方式通常可以利用 Remote Data Access (RDA), Merge Replication, Sync Services for ADO.NET (SQL CE 3.5 中新增) 或者自己实现基于 Web Service 的数据同步机制来实现。RDA 和 Merge Replication 最大的缺点是只能连到 SQL Server 数据库,如果 SQL...
您可以使用Compact方法(在本机编程中为CompactDatabase方法)回收数据库文件中的空间。您还可以使用它来更改数据库设置,例如密码和区域设置 ID (LCID)。 SQL Server Compact 3.5 数据库文件被分割为许多大小为 4 KB 的逻辑单元(称为页)。随着数据库被不断地修改,有些页便可能包含未使用的空间,并且还有些页未得到...