MS SQLCE - Join across SQL ce databases (.sdf files)

Author

Join across SQL ce databases (.sdf files)

Steve

2005-12-13, 11:24 am

We would like to isolate our reference data from our transaction data
into two .sdf files. This will allow us the better manage filters and
scheduling of the publications and agents.

Is it possible to join tables from two .sdf files? If so, what is the
process?

Darren Shaffer

2005-12-13, 8:25 pm

to save you some time, this is not possible.

you can certainly have two connections to two sql ce/mobile
databases, but no way to combine these into a single command.

--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

"Steve" < steven_m_fowler@yaho
o.com> wrote in message
news:1134488816.574069.54360@o13g2000cwo.googlegroups.com...
> We would like to isolate our reference data from our transaction data
> into two .sdf files. This will allow us the better manage filters and
> scheduling of the publications and agents.
>
> Is it possible to join tables from two .sdf files? If so, what is the
> process?
>

Sponsored Links