caglarkumanli
asked on
Sql Server 2000 to Sql CE
Hi experts,
I have a SQL Server 2000 database with several tables. And I want to
move the records in this database to SQL CE environment. Is there a
practical way to do this?
Thanks for your responses...
I have a SQL Server 2000 database with several tables. And I want to
move the records in this database to SQL CE environment. Is there a
practical way to do this?
Thanks for your responses...
Q. How can I migrate a SQL Server database from SQL Server to SQL Server CE?
A. You can use the RDA Pull method with the no-tracking option to pull all tables to your SQL Server CE database, along with the data. If you have default values on any columns, referential integrity (RI), or any indexes, you must run the proper data definition commands to create these properties. For more information, please refer to the Introducing Remote Data Access, Planning for RDA, and Implementing RDA topics in SQL Server CE Books Online.
RDA does not pull referential integrity or multiple tables at the same time. RDA pulls only the primary key (PK) index and the table that is specified in the Pull command. You must add back all the referential integrity to the local version of the table by using the ALTER TABLE command.
Both RDA and replication can copy tables from SQL Server to the SQL Server CE database on the device. This is the "easiest" method to use because this method performs data type mappings for you automatically. Replication only works with Microsoft SQL Server 2000. If your requirement is simple, then RDA is for you. However, if you need to change data on both the server and the device, and have that data merge, and the server is SQL Server 2000, consider Replication as the method to use. Replication requires more configuration on the server, because you need to publish the SQL Server data first.
You can also run SQL statements on the local database that is on the device to create and insert data. The grammar for SQL Server CE is a subset of SQL Server.
A. You can use the RDA Pull method with the no-tracking option to pull all tables to your SQL Server CE database, along with the data. If you have default values on any columns, referential integrity (RI), or any indexes, you must run the proper data definition commands to create these properties. For more information, please refer to the Introducing Remote Data Access, Planning for RDA, and Implementing RDA topics in SQL Server CE Books Online.
RDA does not pull referential integrity or multiple tables at the same time. RDA pulls only the primary key (PK) index and the table that is specified in the Pull command. You must add back all the referential integrity to the local version of the table by using the ALTER TABLE command.
Both RDA and replication can copy tables from SQL Server to the SQL Server CE database on the device. This is the "easiest" method to use because this method performs data type mappings for you automatically. Replication only works with Microsoft SQL Server 2000. If your requirement is simple, then RDA is for you. However, if you need to change data on both the server and the device, and have that data merge, and the server is SQL Server 2000, consider Replication as the method to use. Replication requires more configuration on the server, because you need to publish the SQL Server data first.
You can also run SQL statements on the local database that is on the device to create and insert data. The grammar for SQL Server CE is a subset of SQL Server.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks a lot...
make you destop dabase Publication and setup IIs sever then You can Sync