Insert rows from a database.sdf to another database.sdf

  • Thread starter Thread starter Saep
  • Start date Start date
S

Saep

Hi,
I developed an application that use SqlCe.
I would insert rows of a table from A.sdf to B.sdf with a Sql String.
How Can I make this?

Thanks
Marco Figini
 
With SQL CE 2.0 you will have to create some intermediary storage because
the database engine only allows one one open database at a time. Maybe you
can use a file for this?
 
Hi,
I'm not sure to understand... You tell to export my table (A.sdf) to a
text file and then import the text file to the table in B.sdf?

Marco
 
Pull the data from A into a dataset, disconnect, then connect to B and push
it in.

--
Chris Tacke
Co-founder
OpenNETCF.org
Are you using the SDF? Let's do a case study.
Email us at d c s @ o p e n n e t c f . c o m
http://www.opennetcf.org/donate
 
Back
Top