How can I create one .sdf file.

I have my Database in Sql (mdf and ldf ) and I like know how to convert this
to .sdf file to use
in my new system in pocket..

Tanks Advanced.

Rafael

Rafael,

Generally sdf files need to be created on the device itself in the current
version of SqlCe. One approach is to export the data from your database into
XML and then write a little .NetCF app that reads the XML into a DataSet,
creates the sdf file and writes out the data. (You could also create the sdf
file on the emulator using the same approach.)

There is also a 3rd party product called RemoteSqlCe that allows you to
create sdf files on the device from a desktop app. There's more info here:
http://www.gui-innovations.com/html/remotesqlce.html
--
Ginny Caughey
..Net Compact Framework MVP

"Rafael Metring" <(E-Mail Removed)> wrote in message
news:OuLJj49%(E-Mail Removed)...
> How can I create one .sdf file.
>
> I have my Database in Sql (mdf and ldf ) and I like know how to convert
this
> to .sdf file to use
> in my new system in pocket..
>
> Tanks Advanced.
>
> Rafael
>
>

Considering MS want to keep the SQLCE code/format secret, how can a
third-party developer create such an application? I know you can investigate
the file format of the db and "reverse engineer" it from that, but this is
not a very safe/stable way of doing it, is it? On the other hand, with
sufficient testing (whenever that is) you could always come up with a "good
enough" application I guess...

/ Peter


"Ginny Caughey [MVP]" <(E-Mail Removed)> wrote in message
news:O0qj7F%23%(E-Mail Removed)...
> Rafael,
>
> Generally sdf files need to be created on the device itself in the current
> version of SqlCe. One approach is to export the data from your database
into
> XML and then write a little .NetCF app that reads the XML into a DataSet,
> creates the sdf file and writes out the data. (You could also create the
sdf
> file on the emulator using the same approach.)
>
> There is also a 3rd party product called RemoteSqlCe that allows you to
> create sdf files on the device from a desktop app. There's more info here:
> http://www.gui-innovations.com/html/remotesqlce.html
> --
> Ginny Caughey
> .Net Compact Framework MVP
>
> "Rafael Metring" <(E-Mail Removed)> wrote in message
> news:OuLJj49%(E-Mail Removed)...
> > How can I create one .sdf file.
> >
> > I have my Database in Sql (mdf and ldf ) and I like know how to convert
> this
> > to .sdf file to use
> > in my new system in pocket..
> >
> > Tanks Advanced.
> >
> > Rafael
> >
> >
>
>

The app in question still uses SqlServerCe to create its database file, what
it offers is the ability to create and manipulate the database remotely from
the desktop pc.

Peter

--
Peter Foot
Windows Embedded MVP
OpenNETCF.org Senior Advisor
www.inthehand.com | www.opennetcf.org

"Peter B" <(E-Mail Removed)> wrote in message
news:u2hZDGE$(E-Mail Removed)...
> Considering MS want to keep the SQLCE code/format secret, how can a
> third-party developer create such an application? I know you can
investigate
> the file format of the db and "reverse engineer" it from that, but this is
> not a very safe/stable way of doing it, is it? On the other hand, with
> sufficient testing (whenever that is) you could always come up with a
"good
> enough" application I guess...
>
> / Peter
>
>
> "Ginny Caughey [MVP]" <(E-Mail Removed)> wrote in
message
> news:O0qj7F%23%(E-Mail Removed)...
> > Rafael,
> >
> > Generally sdf files need to be created on the device itself in the
current
> > version of SqlCe. One approach is to export the data from your database
> into
> > XML and then write a little .NetCF app that reads the XML into a
DataSet,
> > creates the sdf file and writes out the data. (You could also create the
> sdf
> > file on the emulator using the same approach.)
> >
> > There is also a 3rd party product called RemoteSqlCe that allows you to
> > create sdf files on the device from a desktop app. There's more info
here:
> > http://www.gui-innovations.com/html/remotesqlce.html
> > --
> > Ginny Caughey
> > .Net Compact Framework MVP
> >
> > "Rafael Metring" <(E-Mail Removed)> wrote in message
> > news:OuLJj49%(E-Mail Removed)...
> > > How can I create one .sdf file.
> > >
> > > I have my Database in Sql (mdf and ldf ) and I like know how to
convert
> > this
> > > to .sdf file to use
> > > in my new system in pocket..
> > >
> > > Tanks Advanced.
> > >
> > > Rafael
> > >
> > >
> >
> >
>
>

Aha! :-)



"Peter Foot [MVP]" <(E-Mail Removed)> wrote in message
news:OGxZRlE$(E-Mail Removed)...
> The app in question still uses SqlServerCe to create its database file,
what
> it offers is the ability to create and manipulate the database remotely
from
> the desktop pc.
>
> Peter
>
> --
> Peter Foot
> Windows Embedded MVP
> OpenNETCF.org Senior Advisor
> www.inthehand.com | www.opennetcf.org
>
> "Peter B" <(E-Mail Removed)> wrote in message
> news:u2hZDGE$(E-Mail Removed)...
> > Considering MS want to keep the SQLCE code/format secret, how can a
> > third-party developer create such an application? I know you can
> investigate
> > the file format of the db and "reverse engineer" it from that, but this
is
> > not a very safe/stable way of doing it, is it? On the other hand, with
> > sufficient testing (whenever that is) you could always come up with a
> "good
> > enough" application I guess...
> >
> > / Peter
> >
> >
> > "Ginny Caughey [MVP]" <(E-Mail Removed)> wrote in
> message
> > news:O0qj7F%23%(E-Mail Removed)...
> > > Rafael,
> > >
> > > Generally sdf files need to be created on the device itself in the
> current
> > > version of SqlCe. One approach is to export the data from your
database
> > into
> > > XML and then write a little .NetCF app that reads the XML into a
> DataSet,
> > > creates the sdf file and writes out the data. (You could also create
the
> > sdf
> > > file on the emulator using the same approach.)
> > >
> > > There is also a 3rd party product called RemoteSqlCe that allows you
to
> > > create sdf files on the device from a desktop app. There's more info
> here:
> > > http://www.gui-innovations.com/html/remotesqlce.html
> > > --
> > > Ginny Caughey
> > > .Net Compact Framework MVP
> > >
> > > "Rafael Metring" <(E-Mail Removed)> wrote in message
> > > news:OuLJj49%(E-Mail Removed)...
> > > > How can I create one .sdf file.
> > > >
> > > > I have my Database in Sql (mdf and ldf ) and I like know how to
> convert
> > > this
> > > > to .sdf file to use
> > > > in my new system in pocket..
> > > >
> > > > Tanks Advanced.
> > > >
> > > > Rafael
> > > >
> > > >
> > >
> > >
> >
> >
>
>

I was reading that Access 2000 can generate SDF file ,it's true?

Rafael

"Peter B" <(E-Mail Removed)> escreveu na mensagem
news:eAQOkHF$(E-Mail Removed)...
> Aha! :-)
>
>
>
> "Peter Foot [MVP]" <(E-Mail Removed)> wrote in message
> news:OGxZRlE$(E-Mail Removed)...
> > The app in question still uses SqlServerCe to create its database file,
> what
> > it offers is the ability to create and manipulate the database remotely
> from
> > the desktop pc.
> >
> > Peter
> >
> > --
> > Peter Foot
> > Windows Embedded MVP
> > OpenNETCF.org Senior Advisor
> > www.inthehand.com | www.opennetcf.org
> >
> > "Peter B" <(E-Mail Removed)> wrote in message
> > news:u2hZDGE$(E-Mail Removed)...
> > > Considering MS want to keep the SQLCE code/format secret, how can a
> > > third-party developer create such an application? I know you can
> > investigate
> > > the file format of the db and "reverse engineer" it from that, but
this
> is
> > > not a very safe/stable way of doing it, is it? On the other hand, with
> > > sufficient testing (whenever that is) you could always come up with a
> > "good
> > > enough" application I guess...
> > >
> > > / Peter
> > >
> > >
> > > "Ginny Caughey [MVP]" <(E-Mail Removed)> wrote in
> > message
> > > news:O0qj7F%23%(E-Mail Removed)...
> > > > Rafael,
> > > >
> > > > Generally sdf files need to be created on the device itself in the
> > current
> > > > version of SqlCe. One approach is to export the data from your
> database
> > > into
> > > > XML and then write a little .NetCF app that reads the XML into a
> > DataSet,
> > > > creates the sdf file and writes out the data. (You could also create
> the
> > > sdf
> > > > file on the emulator using the same approach.)
> > > >
> > > > There is also a 3rd party product called RemoteSqlCe that allows you
> to
> > > > create sdf files on the device from a desktop app. There's more info
> > here:
> > > > http://www.gui-innovations.com/html/remotesqlce.html
> > > > --
> > > > Ginny Caughey
> > > > .Net Compact Framework MVP
> > > >
> > > > "Rafael Metring" <(E-Mail Removed)> wrote in message
> > > > news:OuLJj49%(E-Mail Removed)...
> > > > > How can I create one .sdf file.
> > > > >
> > > > > I have my Database in Sql (mdf and ldf ) and I like know how to
> > convert
> > > > this
> > > > > to .sdf file to use
> > > > > in my new system in pocket..
> > > > >
> > > > > Tanks Advanced.
> > > > >
> > > > > Rafael
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Rafael,

Access can't generate a SQLCe file.
--
Ginny Caughey
..Net Compact Framework MVP

"Rafael Metring" <(E-Mail Removed)> wrote in message
news:%23Yq7LMG$(E-Mail Removed)...
> I was reading that Access 2000 can generate SDF file ,it's true?
>
> Rafael
>
> "Peter B" <(E-Mail Removed)> escreveu na mensagem
> news:eAQOkHF$(E-Mail Removed)...
> > Aha! :-)
> >
> >
> >
> > "Peter Foot [MVP]" <(E-Mail Removed)> wrote in message
> > news:OGxZRlE$(E-Mail Removed)...
> > > The app in question still uses SqlServerCe to create its database
file,
> > what
> > > it offers is the ability to create and manipulate the database
remotely
> > from
> > > the desktop pc.
> > >
> > > Peter
> > >
> > > --
> > > Peter Foot
> > > Windows Embedded MVP
> > > OpenNETCF.org Senior Advisor
> > > www.inthehand.com | www.opennetcf.org
> > >
> > > "Peter B" <(E-Mail Removed)> wrote in message
> > > news:u2hZDGE$(E-Mail Removed)...
> > > > Considering MS want to keep the SQLCE code/format secret, how can a
> > > > third-party developer create such an application? I know you can
> > > investigate
> > > > the file format of the db and "reverse engineer" it from that, but
> this
> > is
> > > > not a very safe/stable way of doing it, is it? On the other hand,
with
> > > > sufficient testing (whenever that is) you could always come up with
a
> > > "good
> > > > enough" application I guess...
> > > >
> > > > / Peter
> > > >
> > > >
> > > > "Ginny Caughey [MVP]" <(E-Mail Removed)> wrote in
> > > message
> > > > news:O0qj7F%23%(E-Mail Removed)...
> > > > > Rafael,
> > > > >
> > > > > Generally sdf files need to be created on the device itself in the
> > > current
> > > > > version of SqlCe. One approach is to export the data from your
> > database
> > > > into
> > > > > XML and then write a little .NetCF app that reads the XML into a
> > > DataSet,
> > > > > creates the sdf file and writes out the data. (You could also
create
> > the
> > > > sdf
> > > > > file on the emulator using the same approach.)
> > > > >
> > > > > There is also a 3rd party product called RemoteSqlCe that allows
you
> > to
> > > > > create sdf files on the device from a desktop app. There's more
info
> > > here:
> > > > > http://www.gui-innovations.com/html/remotesqlce.html
> > > > > --
> > > > > Ginny Caughey
> > > > > .Net Compact Framework MVP
> > > > >
> > > > > "Rafael Metring" <(E-Mail Removed)> wrote in message
> > > > > news:OuLJj49%(E-Mail Removed)...
> > > > > > How can I create one .sdf file.
> > > > > >
> > > > > > I have my Database in Sql (mdf and ldf ) and I like know how to
> > > convert
> > > > > this
> > > > > > to .sdf file to use
> > > > > > in my new system in pocket..
> > > > > >
> > > > > > Tanks Advanced.
> > > > > >
> > > > > > Rafael
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>