Oracle to SQLCe

Hi,

Could some one in copying data from Oracle to MS SQLCe, I have the entire table structure on SQLCe.

I want to do it progamatically, if there is tool which will do this activity I am also fine with that.

Hi,

Could you please guide me how to copy data from Oracle to MS SQLCe, I have the entire table structure on SQLCe.

I want to do it progamatically, if there is tool which will do this activity I am also fine with that.

|||

There is no "bulk copy" import facility for SQLCe or class in the namespace that can automate this, but there are a few approaches you might try.

1) Create a Subscription to the Oracle table(s) this would require you to setup a merge replication Publisher on SQL Server Workgroup and import the data there (I expect) before starting. This approach builds the schema on the SqlCe database and imports the data via a merge snapshot.

2) Execute a query against the Oracle database using the OracleClient namespace. This returns one or more DataTable objects. Walk walk through these table(s) and roll your own DDL and INSERT statements and execute them against the SQLCe engine database. This will be expensive code-wise and time-wise but should work reliably.

Other suggestions are encouraged.