[RESOLVED] Sql ce

[TheUsed]

Hello, i need to have my phone sync with a server database. Can I use activesync to grab my exchange server certificate and do the rest that way?

I was thinking I can have it sync when my exchange server syncs my phone.

Or

I might want to have an option to sync right upon writing to the DB on my Phone.

How can I do this?

I know what i need to have installed and what not. I need to know where to start programmatically.

I am not going to use a web service. I will be using a straight connection to the server DB. or the Server APP I make then have that save to the DB.

[petevick]

Depending on your server database you have a coice of
Replication
RDA
Microsoft Sync Services
SQLClient and handle it yourself

Really need to know what you are trying to do in more detail

[TheUsed]

I am making a phone application for my IT department. On the phone i'll be storing to a local database, then at random times or specific times i want to send that database stored locally to a database on one of our servers.. Currently we have our phones set up to our exchange server.

I want to send the local DB file without using a web app.

I am running SQL 2005 express. as well as SQL CE server. on a desktop computer.

[petevick]

In that case, sync services, or handle it yourself using SqlClient to update the database directly.

As noted earlier today, SQL Express cannot act as a replication publisher

[TheUsed]

As noted earlier today, SQL Express cannot act as a replication publisher

What do you mean?

[GaryMazzone]

look at this page:

http://www.databasejournal.com/featu...on-Support.htm

Or read here:

http://databases.about.com/cs/sqlserver/a/aa041303a.htm

[TheUsed]

Ok I skimmed this information. As a quick question hoping for a quick answer.

Will I beable to use Standard SQL to connect from my phone to sync?

[petevick]

What do you mean by standard SQL?

If you mean can you open the SQL Express database from your phone over wireless/gprs/activesync and read/write to it yes?

Otherwise can you explain?

[TheUsed]

by Standard SQL I meant SQL Standard...

However if i can do this with express then good.. can anyone inform me of how or have code examples showing this?

[petevick]

Sorry - what do you mean by Sync?

You can use SyncServices but not replication.

If you just want to 'roll your own' - use the SQLClient namespace and just access the database as you would from the desktop

[TheUsed]

Sync= Synchronize.

So with SyncServices I can connect to the database running on SQL Express and Sync at a specific time? Anyone attempted this and willing to provide code examples?

[petevick]

I understand that sync=synchronise - I was asking which particular method you wanted to use.
For Sync Services one of my colleagues has an excellent webcast here - but Sync Services is not for the faint hearted.

If it is only a simple one-table update, I would seriously look at SqlClient and updatind the database directly on a timely basis

[TheUsed]

I can connect from SQL CE on a phone to SQL 2005 express With a Connection String that contains an IP? because in the example connectionstrings i've seen for SQL CE it was all done locally.

[TheUsed]

i will be sure to watch that webcase, thank you for the post.

[techgnome]

SQL CE is designed for mobile apps... it's a much smaller footprint than full blown SQL Server, which would never fit on a mobile device. As such, there is a SQLCEClient namespace that is designed to work with it. So you sue SQLCEClient to connect to a SQL CE database... generally that is on the local system. So if you're using the mobile device as the storage, then I'd suggest learning to use SQL CE. If, however, you are wanting to connect to a database that is on the network, and is NOT a SQL CE database... then go with the SQLClient namespace. But it DEPENDS on WHERE the database is located that you want to talk to.

-tg

[TheUsed]

After watching that Webcast i decided to go with replication. Seems easiest with the type of application im doing. Thank you all for the help.