Ok, this time I said another protagonist: MS SQL Server 2005 Mobile Edition, is the name long? Later, it is good, it is the upgrade version of SQL Server CE 2.0, in fact, SQL CE 3.0.
SQL Mobile changes, the biggest change is to add support for multi-platform. SQL Mobile will be supported by tablet PC and the next version of PC, Smartphone, and does not need to be converted. This is actually not so strange. In Windows Mobile 2003, the database file generated on the simulator can be run on the actual device, which means that the database format is not related to the CPU. In addition, there is a message that the SQL Mobile database can be edited on the PC, which means that SQL Mobile has also supported the PC platform (note, free!). The biggest progress is that the SmartPhone finally supports the database.
For some problems of SQL CE, improvements in reliability and efficiency are carried out. Improvements mainly include three aspects: data synchronization, storage management, and query procedures.
Let's first look at the data synchronization: Everyone knows that SQL CE 2.0 supports replication (Replication) and RDA synchronization mode. First, copy, SQL Mobile supports multiple subscriptions. Previous databases can only support a subscription. If the developer wants to release multiple data sources, create a separate subscription database. In the SQL Mobile, multiple subscriptions can be included in a database.
The following features are important, support multi-user access and synchronization. Everyone should still remember that when you do SQL CE development, once you open the query analyzer, you cannot successfully access the database, this problem is finally solved.
Synchronous state feedback, developers can use the hosting API to understand the feedback of the synchronous state, can tell the user to synchronize the process.
Column-Level Tracking, previous SQL CE, if a data in a data line is modified, when synchronization, you will synchronize the entire data line, and now you will only synchronize the modified data item. Everyone knows that the previous tracking is completed by adding two data columns, I don't know how they do it now. But I always feel that this will waste some space, I hope that SQL Mobile is not too slow.
Next is the storage engine section, in Microsoft's document, SQL Mobile's storage engine is rewritten, and its architecture is suitable for mobile device batteries and connectivity. All applications will share a public memory pool, which may also be due to the increase of the reasons for multi-user support.
SQL Mobile provides multi-user support for row-level locking, Locking and independent levels of the data page for multi-user support.
Automatically recycle empty data pages, SQL Mobile will automatically return the unused data pages to save the storage space of the device.
Inquiries process access, SQL Mobile provides cost-based optimization, providing execution planning and query hints, allowing developers to view query plans, and optimize the entire query plan according to equipment details such as CPU speed, media access time.
SQL Mobile also provides a SQLceResultset object that is an updateable, data access object that can control the cursor, which can use this object to access the database directly without having a dual cache data. This object also supports WinForm's data binding interface, which can be bound by controls such as DataGrid, TextBox, Listbox.
SQL Mobile can be integrated into SQL Server 2005 and Visual Studio 2005 to create and test the SQL Server Mobile database creation convenience. First, SQL Server 2005 provides an app called SQL Server Management Studio (not knowing what is called Chinese name), replacing SQL Server's Enterprise Manager and Query Analyzer. This tool can manage a SQL Mobile database on the PC. Oh, is it very attractive to use the same database on the PC and mobile devices?
SQL Server 2005 provides a graphical query execution view, a new subscription wizard, improving the web configuration wizard, the new configuration wizard supports the virtual directory of HTTPS, and configures the remote IIS server.
Data Conversion Services (DTS) is newly added features that can be converted between SQL Mobile databases and Access, Oracle, and IBM DB2.
SQL Editor will be the main tool for SQL Server Management Studio to design and test T-SQL queries or scripts.
There is also a database deployment. SQL Server Management Studio can create a SQL Mobile database, design data sheets, populate data, and publish them into different devices on the local machine.
Here are the improvements of the VS.NET 2005 for SQL Mobile. Developers can manage SQL Mobile databases in desktop computers and mobile devices using VS.NET 2005. Developers can drag a SQL Mobile table to a control of the mobile app, the control will automatically bind to this table.
VS.NET 2005 also provides a "My Computer Deployment" feature that can help you deploy SQL Mobile to your PC so that mobile applications can run in the .NET Framework environment. Everyone still remembers that if a program with SQL CE is running in .NET, it will report an exception that the system does not support, it seems that this time will not.
Ok, these are some information about SQL Mobile. Let us look forward to the arrival of Beta 2.
