[Translation] FAQs about SQL ce RDA Data Synchronization

Q1. How can we determine whether a table with RDA pulled is tracked? What is an RDA subscription table?
A1.System Table _ sysrdasubscriptions stores the RDA subscription information. If the tracking option is enabled when the table is pulled down (rdatrackoption. trackingon or rdatrackoption. trackingonwithindexes), this table is the RDA subscription table. The system table adds a record for it. In short, if the pulled table has a corresponding record in the _ sysrdasubscriptions table, it will be tracked. Similarly, if the tracking option is not enabled when the table is pulled down, the table will not have any RDA subscription information.

Q2. Why do I get the "ssce_m_restrictedddl-28605-internal error: DDL operations are not allowed on system tables. [, table name,]" error? What does this error mean?
A2.When you use RDA to pull a table and set the tracking on option (or when a table is subscribed by RDA), the DDL operations on the table are limited, therefore, we maintain the integrity of the architecture by copying data from the master table. Therefore, this error occurs when you try to perform DDL operations on the RDA subscription table.

Q3. How to avoid the error "ssce_m_tablealreadyexists-28573-The localtablename parameter is already specified. [, table name?
A3.This error is thrown when the local table name or the table corresponding to the wrong table name already exists in the pull command parameter of RDA. There are two ways to avoid this error: 1) Delete the table that caused the error 2) Change the RDA pull parameter.

Q4. How to avoid the error "duplicate value cannot be inserted into a unique index. [Table name = _ sysrdasubscriptions, constraint name = c_localtablename?
A4.Under normal circumstances, this error should not occur. However, there is a defect that can cause this error. This defect is discussed in detail in KB article 920272. If you are using vs2005 SP1, you will not encounter this error again. If you encounter this errorProgramFiles and customer applications are stored in the same directory (difficult to understand-_-), preferably the \ Windows directory.

Q5. How can I change the identity information after executing RDA pull? Because RDA does not support identity range management ).
A5.Although tables pulled by RDA are subject to DDL constraints, changing the default value and ID information is not limited. You can use the alter table <Table Name> alter column <column Name> <int | bigint> identity (<new seed>, <New Step>) statement to modify the ID information.

Original article: RDA subscriptions

[Glossary]
RDA: remotedataaccess, SQL Server CE's Remote Data Access synchronization method. For more information, see the technical comparison of replication and remote data access functions in SQL Server 2005 mobile edition 3.0.
DDL: Data Definition Language.

if your translation is poor due to your limited translation level, please refer to the original article. Thank you for your correction!