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

Re: How to create .sdf file by Ginny

Ginny
Wed Feb 25 14:53:32 CST 2004

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" <rafael_metring@pop.com.br> wrote in message
news:OuLJj49%23DHA.792@TK2MSFTNGP11.phx.gbl...
> 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
>
>



Re: How to create .sdf file by Peter

Peter
Thu Feb 26 02:20:37 CST 2004

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]" <ginny.caughey.online@wasteworks.com> wrote in message
news:O0qj7F%23%23DHA.3536@TK2MSFTNGP10.phx.gbl...
> 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" <rafael_metring@pop.com.br> wrote in message
> news:OuLJj49%23DHA.792@TK2MSFTNGP11.phx.gbl...
> > 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
> >
> >
>
>



Re: How to create .sdf file by Peter

Peter
Thu Feb 26 03:17:08 CST 2004

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" <peter@data.se> wrote in message
news:u2hZDGE$DHA.3772@TK2MSFTNGP11.phx.gbl...
> 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]" <ginny.caughey.online@wasteworks.com> wrote in
message
> news:O0qj7F%23%23DHA.3536@TK2MSFTNGP10.phx.gbl...
> > 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" <rafael_metring@pop.com.br> wrote in message
> > news:OuLJj49%23DHA.792@TK2MSFTNGP11.phx.gbl...
> > > 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
> > >
> > >
> >
> >
>
>



Re: How to create .sdf file by Peter

Peter
Thu Feb 26 04:17:51 CST 2004

Aha! :-)



"Peter Foot [MVP]" <feedback@nospam-inthehand.com> wrote in message
news:OGxZRlE$DHA.2808@TK2MSFTNGP10.phx.gbl...
> 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" <peter@data.se> wrote in message
> news:u2hZDGE$DHA.3772@TK2MSFTNGP11.phx.gbl...
> > 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]" <ginny.caughey.online@wasteworks.com> wrote in
> message
> > news:O0qj7F%23%23DHA.3536@TK2MSFTNGP10.phx.gbl...
> > > 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" <rafael_metring@pop.com.br> wrote in message
> > > news:OuLJj49%23DHA.792@TK2MSFTNGP11.phx.gbl...
> > > > 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
> > > >
> > > >
> > >
> > >
> >
> >
>
>



Re: How to create .sdf file by Rafael

Rafael
Thu Feb 26 06:21:32 CST 2004

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

Rafael

"Peter B" <peter@data.se> escreveu na mensagem
news:eAQOkHF$DHA.2808@TK2MSFTNGP10.phx.gbl...
> Aha! :-)
>
>
>
> "Peter Foot [MVP]" <feedback@nospam-inthehand.com> wrote in message
> news:OGxZRlE$DHA.2808@TK2MSFTNGP10.phx.gbl...
> > 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" <peter@data.se> wrote in message
> > news:u2hZDGE$DHA.3772@TK2MSFTNGP11.phx.gbl...
> > > 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]" <ginny.caughey.online@wasteworks.com> wrote in
> > message
> > > news:O0qj7F%23%23DHA.3536@TK2MSFTNGP10.phx.gbl...
> > > > 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" <rafael_metring@pop.com.br> wrote in message
> > > > news:OuLJj49%23DHA.792@TK2MSFTNGP11.phx.gbl...
> > > > > 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
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>



Re: How to create .sdf file by Ginny

Ginny
Thu Feb 26 07:50:11 CST 2004

Rafael,

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

"Rafael Metring" <rafael_metring@pop.com.br> wrote in message
news:%23Yq7LMG$DHA.3352@TK2MSFTNGP09.phx.gbl...
> I was reading that Access 2000 can generate SDF file ,it's true?
>
> Rafael
>
> "Peter B" <peter@data.se> escreveu na mensagem
> news:eAQOkHF$DHA.2808@TK2MSFTNGP10.phx.gbl...
> > Aha! :-)
> >
> >
> >
> > "Peter Foot [MVP]" <feedback@nospam-inthehand.com> wrote in message
> > news:OGxZRlE$DHA.2808@TK2MSFTNGP10.phx.gbl...
> > > 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" <peter@data.se> wrote in message
> > > news:u2hZDGE$DHA.3772@TK2MSFTNGP11.phx.gbl...
> > > > 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]" <ginny.caughey.online@wasteworks.com> wrote in
> > > message
> > > > news:O0qj7F%23%23DHA.3536@TK2MSFTNGP10.phx.gbl...
> > > > > 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" <rafael_metring@pop.com.br> wrote in message
> > > > > news:OuLJj49%23DHA.792@TK2MSFTNGP11.phx.gbl...
> > > > > > 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
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>