How to make a local database

Hello,

I am sorry about the earlier question I guess I did not reword it
correctly. I want to make a local database in my pockPC where I can
read and write to the tables locally in my PocketPC. I know the
SQLComand, SQLConnection, etc are not for local databases they are
designed to access the SQL Server, I also know the SQLCe is designed
for mobile hand held communication and website/server communication.
Does anyone know a link for a tutorial, etc that will teach me how to
make/access a local server in my pocketPC so I can add data into the
local table, update data into the local table, etc? Thanks in advance.
My boss (manager) tells me that the whole reason they made SQLCe is for
that purpose, if so, is there a tutorial to teach me to make a local
SQL server. I also don't know how to make .sdf file? Where would I be
able to do that? Thanks in advance.

Look at the classes in System.Data.SQLServerCE. To create a new database,
look at SqlCeEngine. The other classes are pretty self-explanatory when
used in combination with the help. Obviously, SQLServerCE has to be on the
device...

Paul T.

<amiga500@gmail.com> wrote in message
news:1165339245.612816.62130@16g2000cwy.googlegroups.com...
> Hello,
>
> I am sorry about the earlier question I guess I did not reword it
> correctly. I want to make a local database in my pockPC where I can
> read and write to the tables locally in my PocketPC. I know the
> SQLComand, SQLConnection, etc are not for local databases they are
> designed to access the SQL Server, I also know the SQLCe is designed
> for mobile hand held communication and website/server communication.
> Does anyone know a link for a tutorial, etc that will teach me how to
> make/access a local server in my pocketPC so I can add data into the
> local table, update data into the local table, etc? Thanks in advance.
> My boss (manager) tells me that the whole reason they made SQLCe is for
> that purpose, if so, is there a tutorial to teach me to make a local
> SQL server. I also don't know how to make .sdf file? Where would I be
> able to do that? Thanks in advance.
>

But how do you make your own .sdf file though? Is SQLServeCE similiar
to the SQL Enterprise manager for windows, but it is local and for
pocketPC, allowing one full power to make their own tables?

On Dec 5, 12:46 pm, "Paul G. Tobey [eMVP]" <p space tobey no spam AT no
instrument no spam DOT com> wrote:
> Look at the classes in System.Data.SQLServerCE. To create a new database,
> look at SqlCeEngine. The other classes are pretty self-explanatory when
> used in combination with the help. Obviously, SQLServerCE has to be on the
> device...
>
> Paul T.
>
> <amiga...@gmail.com> wrote in messagenews:1165339245.612816.62130@16g2000cwy.googlegroups.com...
>
> > Hello,
>
> > I am sorry about the earlier question I guess I did not reword it
> > correctly. I want to make a local database in my pockPC where I can
> > read and write to the tables locally in my PocketPC. I know the
> > SQLComand, SQLConnection, etc are not for local databases they are
> > designed to access the SQL Server, I also know the SQLCe is designed
> > for mobile hand held communication and website/server communication.
> > Does anyone know a link for a tutorial, etc that will teach me how to
> > make/access a local server in my pocketPC so I can add data into the
> > local table, update data into the local table, etc? Thanks in advance.
> > My boss (manager) tells me that the whole reason they made SQLCe is for
> > that purpose, if so, is there a tutorial to teach me to make a local
> > SQL server. I also don't know how to make .sdf file? Where would I be
> > able to do that? Thanks in advance.

I have no idea how SQL Enterprise manager for windows works. You create new
databases by following my instructions from the previous message...

Paul T.

<amiga500@gmail.com> wrote in message
news:1165341326.871185.203260@16g2000cwy.googlegroups.com...
> But how do you make your own .sdf file though? Is SQLServeCE similiar
> to the SQL Enterprise manager for windows, but it is local and for
> pocketPC, allowing one full power to make their own tables?
>
> On Dec 5, 12:46 pm, "Paul G. Tobey [eMVP]" <p space tobey no spam AT no
> instrument no spam DOT com> wrote:
>> Look at the classes in System.Data.SQLServerCE. To create a new
>> database,
>> look at SqlCeEngine. The other classes are pretty self-explanatory when
>> used in combination with the help. Obviously, SQLServerCE has to be on
>> the
>> device...
>>
>> Paul T.
>>
>> <amiga...@gmail.com> wrote in
>> messagenews:1165339245.612816.62130@16g2000cwy.googlegroups.com...
>>
>> > Hello,
>>
>> > I am sorry about the earlier question I guess I did not reword it
>> > correctly. I want to make a local database in my pockPC where I can
>> > read and write to the tables locally in my PocketPC. I know the
>> > SQLComand, SQLConnection, etc are not for local databases they are
>> > designed to access the SQL Server, I also know the SQLCe is designed
>> > for mobile hand held communication and website/server communication.
>> > Does anyone know a link for a tutorial, etc that will teach me how to
>> > make/access a local server in my pocketPC so I can add data into the
>> > local table, update data into the local table, etc? Thanks in advance.
>> > My boss (manager) tells me that the whole reason they made SQLCe is for
>> > that purpose, if so, is there a tutorial to teach me to make a local
>> > SQL server. I also don't know how to make .sdf file? Where would I be
>> > able to do that? Thanks in advance.
>

Your previous message says I should use SQLCeEngine and use SQLServerCE
on the actual PocketPC. I don't know how to do either of them. Please,
do you know a tutorial link where it teaches the person how to use
SQLCeEngine and how to setup SQLServeCE on the pocketPC? Thanks in
advance.

On Dec 5, 1:05 pm, "Paul G. Tobey [eMVP]" <p space tobey no spam AT no
instrument no spam DOT com> wrote:
> I have no idea how SQL Enterprise manager for windows works. You create new
> databases by following my instructions from the previous message...
>
> Paul T.
>
> <amiga...@gmail.com> wrote in messagenews:1165341326.871185.203260@16g2000cwy.googlegroups.com...
>
> > But how do you make your own .sdf file though? Is SQLServeCE similiar
> > to the SQL Enterprise manager for windows, but it is local and for
> > pocketPC, allowing one full power to make their own tables?
>
> > On Dec 5, 12:46 pm, "Paul G. Tobey [eMVP]" <p space tobey no spam AT no
> > instrument no spam DOT com> wrote:
> >> Look at the classes in System.Data.SQLServerCE. To create a new
> >> database,
> >> look at SqlCeEngine. The other classes are pretty self-explanatory when
> >> used in combination with the help. Obviously, SQLServerCE has to be on
> >> the
> >> device...
>
> >> Paul T.
>
> >> <amiga...@gmail.com> wrote in
> >> messagenews:1165339245.612816.62130@16g2000cwy.googlegroups.com...
>
> >> > Hello,
>
> >> > I am sorry about the earlier question I guess I did not reword it
> >> > correctly. I want to make a local database in my pockPC where I can
> >> > read and write to the tables locally in my PocketPC. I know the
> >> > SQLComand, SQLConnection, etc are not for local databases they are
> >> > designed to access the SQL Server, I also know the SQLCe is designed
> >> > for mobile hand held communication and website/server communication.
> >> > Does anyone know a link for a tutorial, etc that will teach me how to
> >> > make/access a local server in my pocketPC so I can add data into the
> >> > local table, update data into the local table, etc? Thanks in advance.
> >> > My boss (manager) tells me that the whole reason they made SQLCe is for
> >> > that purpose, if so, is there a tutorial to teach me to make a local
> >> > SQL server. I also don't know how to make .sdf file? Where would I be
> >> > able to do that? Thanks in advance.

I just did a Google search for "sql mobile tutorial" and the #1 response
looks very, very good.


--
Chris Tacke
OpenNETCF Consulting
Managed Code in the Embedded World
www.opennetcf.com
--


<amiga500@gmail.com> wrote in message
news:1165342375.478348.176790@n67g2000cwd.googlegroups.com...
> Your previous message says I should use SQLCeEngine and use SQLServerCE
> on the actual PocketPC. I don't know how to do either of them. Please,
> do you know a tutorial link where it teaches the person how to use
> SQLCeEngine and how to setup SQLServeCE on the pocketPC? Thanks in
> advance.
>
> On Dec 5, 1:05 pm, "Paul G. Tobey [eMVP]" <p space tobey no spam AT no
> instrument no spam DOT com> wrote:
>> I have no idea how SQL Enterprise manager for windows works. You create
>> new
>> databases by following my instructions from the previous message...
>>
>> Paul T.
>>
>> <amiga...@gmail.com> wrote in
>> messagenews:1165341326.871185.203260@16g2000cwy.googlegroups.com...
>>
>> > But how do you make your own .sdf file though? Is SQLServeCE similiar
>> > to the SQL Enterprise manager for windows, but it is local and for
>> > pocketPC, allowing one full power to make their own tables?
>>
>> > On Dec 5, 12:46 pm, "Paul G. Tobey [eMVP]" <p space tobey no spam AT no
>> > instrument no spam DOT com> wrote:
>> >> Look at the classes in System.Data.SQLServerCE. To create a new
>> >> database,
>> >> look at SqlCeEngine. The other classes are pretty self-explanatory
>> >> when
>> >> used in combination with the help. Obviously, SQLServerCE has to be
>> >> on
>> >> the
>> >> device...
>>
>> >> Paul T.
>>
>> >> <amiga...@gmail.com> wrote in
>> >> messagenews:1165339245.612816.62130@16g2000cwy.googlegroups.com...
>>
>> >> > Hello,
>>
>> >> > I am sorry about the earlier question I guess I did not reword it
>> >> > correctly. I want to make a local database in my pockPC where I can
>> >> > read and write to the tables locally in my PocketPC. I know the
>> >> > SQLComand, SQLConnection, etc are not for local databases they are
>> >> > designed to access the SQL Server, I also know the SQLCe is designed
>> >> > for mobile hand held communication and website/server communication.
>> >> > Does anyone know a link for a tutorial, etc that will teach me how
>> >> > to
>> >> > make/access a local server in my pocketPC so I can add data into the
>> >> > local table, update data into the local table, etc? Thanks in
>> >> > advance.
>> >> > My boss (manager) tells me that the whole reason they made SQLCe is
>> >> > for
>> >> > that purpose, if so, is there a tutorial to teach me to make a local
>> >> > SQL server. I also don't know how to make .sdf file? Where would I
>> >> > be
>> >> > able to do that? Thanks in advance.
>

You can use SQL Server Management Studio (but not the version that comes
with SQL Express) or Visual Studio 2005 to create SQL Mobile databases. You
can also create them programmatically as Paul suggested.

--
Ginny Caughey
Device Application Development MVP


<amiga500@gmail.com> wrote in message
news:1165341326.871185.203260@16g2000cwy.googlegroups.com...
> But how do you make your own .sdf file though? Is SQLServeCE similiar
> to the SQL Enterprise manager for windows, but it is local and for
> pocketPC, allowing one full power to make their own tables?
>
> On Dec 5, 12:46 pm, "Paul G. Tobey [eMVP]" <p space tobey no spam AT no
> instrument no spam DOT com> wrote:
>> Look at the classes in System.Data.SQLServerCE. To create a new
>> database,
>> look at SqlCeEngine. The other classes are pretty self-explanatory when
>> used in combination with the help. Obviously, SQLServerCE has to be on
>> the
>> device...
>>
>> Paul T.
>>
>> <amiga...@gmail.com> wrote in
>> messagenews:1165339245.612816.62130@16g2000cwy.googlegroups.com...
>>
>> > Hello,
>>
>> > I am sorry about the earlier question I guess I did not reword it
>> > correctly. I want to make a local database in my pockPC where I can
>> > read and write to the tables locally in my PocketPC. I know the
>> > SQLComand, SQLConnection, etc are not for local databases they are
>> > designed to access the SQL Server, I also know the SQLCe is designed
>> > for mobile hand held communication and website/server communication.
>> > Does anyone know a link for a tutorial, etc that will teach me how to
>> > make/access a local server in my pocketPC so I can add data into the
>> > local table, update data into the local table, etc? Thanks in advance.
>> > My boss (manager) tells me that the whole reason they made SQLCe is for
>> > that purpose, if so, is there a tutorial to teach me to make a local
>> > SQL server. I also don't know how to make .sdf file? Where would I be
>> > able to do that? Thanks in advance.
>

SQLCeEngine is a class which 5 seconds worth of work in the help on your end
would have found. It has methods for creating new databases.

Paul T.

<amiga500@gmail.com> wrote in message
news:1165342375.478348.176790@n67g2000cwd.googlegroups.com...
> Your previous message says I should use SQLCeEngine and use SQLServerCE
> on the actual PocketPC. I don't know how to do either of them. Please,
> do you know a tutorial link where it teaches the person how to use
> SQLCeEngine and how to setup SQLServeCE on the pocketPC? Thanks in
> advance.
>
> On Dec 5, 1:05 pm, "Paul G. Tobey [eMVP]" <p space tobey no spam AT no
> instrument no spam DOT com> wrote:
>> I have no idea how SQL Enterprise manager for windows works. You create
>> new
>> databases by following my instructions from the previous message...
>>
>> Paul T.
>>
>> <amiga...@gmail.com> wrote in
>> messagenews:1165341326.871185.203260@16g2000cwy.googlegroups.com...
>>
>> > But how do you make your own .sdf file though? Is SQLServeCE similiar
>> > to the SQL Enterprise manager for windows, but it is local and for
>> > pocketPC, allowing one full power to make their own tables?
>>
>> > On Dec 5, 12:46 pm, "Paul G. Tobey [eMVP]" <p space tobey no spam AT no
>> > instrument no spam DOT com> wrote:
>> >> Look at the classes in System.Data.SQLServerCE. To create a new
>> >> database,
>> >> look at SqlCeEngine. The other classes are pretty self-explanatory
>> >> when
>> >> used in combination with the help. Obviously, SQLServerCE has to be
>> >> on
>> >> the
>> >> device...
>>
>> >> Paul T.
>>
>> >> <amiga...@gmail.com> wrote in
>> >> messagenews:1165339245.612816.62130@16g2000cwy.googlegroups.com...
>>
>> >> > Hello,
>>
>> >> > I am sorry about the earlier question I guess I did not reword it
>> >> > correctly. I want to make a local database in my pockPC where I can
>> >> > read and write to the tables locally in my PocketPC. I know the
>> >> > SQLComand, SQLConnection, etc are not for local databases they are
>> >> > designed to access the SQL Server, I also know the SQLCe is designed
>> >> > for mobile hand held communication and website/server communication.
>> >> > Does anyone know a link for a tutorial, etc that will teach me how
>> >> > to
>> >> > make/access a local server in my pocketPC so I can add data into the
>> >> > local table, update data into the local table, etc? Thanks in
>> >> > advance.
>> >> > My boss (manager) tells me that the whole reason they made SQLCe is
>> >> > for
>> >> > that purpose, if so, is there a tutorial to teach me to make a local
>> >> > SQL server. I also don't know how to make .sdf file? Where would I
>> >> > be
>> >> > able to do that? Thanks in advance.
>

I thank you all for your very fast reply, patience and understanding. I
have solved my problem thanks to you guys. Appreciate it big time. I
sometimes think you guys should be paid for this ^_^

On Dec 5, 1:27 pm, "Paul G. Tobey [eMVP]" <p space tobey no spam AT no
instrument no spam DOT com> wrote:
> SQLCeEngine is a class which 5 seconds worth of work in the help on your end
> would have found. It has methods for creating new databases.
>
> Paul T.
>
> <amiga...@gmail.com> wrote in messagenews:1165342375.478348.176790@n67g2000cwd.googlegroups.com...
>
> > Your previous message says I should use SQLCeEngine and use SQLServerCE
> > on the actual PocketPC. I don't know how to do either of them. Please,
> > do you know a tutorial link where it teaches the person how to use
> > SQLCeEngine and how to setup SQLServeCE on the pocketPC? Thanks in
> > advance.
>
> > On Dec 5, 1:05 pm, "Paul G. Tobey [eMVP]" <p space tobey no spam AT no
> > instrument no spam DOT com> wrote:
> >> I have no idea how SQL Enterprise manager for windows works. You create
> >> new
> >> databases by following my instructions from the previous message...
>
> >> Paul T.
>
> >> <amiga...@gmail.com> wrote in
> >> messagenews:1165341326.871185.203260@16g2000cwy.googlegroups.com...
>
> >> > But how do you make your own .sdf file though? Is SQLServeCE similiar
> >> > to the SQL Enterprise manager for windows, but it is local and for
> >> > pocketPC, allowing one full power to make their own tables?
>
> >> > On Dec 5, 12:46 pm, "Paul G. Tobey [eMVP]" <p space tobey no spam AT no
> >> > instrument no spam DOT com> wrote:
> >> >> Look at the classes in System.Data.SQLServerCE. To create a new
> >> >> database,
> >> >> look at SqlCeEngine. The other classes are pretty self-explanatory
> >> >> when
> >> >> used in combination with the help. Obviously, SQLServerCE has to be
> >> >> on
> >> >> the
> >> >> device...
>
> >> >> Paul T.
>
> >> >> <amiga...@gmail.com> wrote in
> >> >> messagenews:1165339245.612816.62130@16g2000cwy.googlegroups.com...
>
> >> >> > Hello,
>
> >> >> > I am sorry about the earlier question I guess I did not reword it
> >> >> > correctly. I want to make a local database in my pockPC where I can
> >> >> > read and write to the tables locally in my PocketPC. I know the
> >> >> > SQLComand, SQLConnection, etc are not for local databases they are
> >> >> > designed to access the SQL Server, I also know the SQLCe is designed
> >> >> > for mobile hand held communication and website/server communication.
> >> >> > Does anyone know a link for a tutorial, etc that will teach me how
> >> >> > to
> >> >> > make/access a local server in my pocketPC so I can add data into the
> >> >> > local table, update data into the local table, etc? Thanks in
> >> >> > advance.
> >> >> > My boss (manager) tells me that the whole reason they made SQLCe is
> >> >> > for
> >> >> > that purpose, if so, is there a tutorial to teach me to make a local
> >> >> > SQL server. I also don't know how to make .sdf file? Where would I
> >> >> > be
> >> >> > able to do that? Thanks in advance.