Complete sync between iphone sqlite3 database to sql server 2005 database on the server?

Because the short answer, to the best of my knowledge is not really- with 3 potential options: I've heard of some savvy programmers having a bit of luck writing their own code either using delimited text or XML or the SqlClient provider for . NETCF to move data between the server and sqlite3 database You can do snapshot replication to any ODBC data source. But this might mean either copying your sqlite database to your server or finding another replication product which can go between SQLite and an ODBC desktop database The last option I can think of is to switch from sqlite3 to sql mobile edition / sqlce or sql express (depending on if this is a device or something else) as you would have the option to set up replication or RDA (remote data access) between the those databases and your ms sql server 2005 db- hence the question are you married to sqlite3?

Also- I just was reading about SQL Anywhere (ultralite) from Sybase which is a free solution. This little database has a pretty small footprint and also support MobiLink Synchronization Wizard which allows you to setup replication with your MS 2005 db. Here is a moderately useful article about MobiLink Synchronization if you decide to consider option 3 here are some articles to help set up RDA or Replication with your db's.

Because the short answer, to the best of my knowledge is not really- with 3 potential options: I've heard of some savvy programmers having a bit of luck writing their own code either using delimited text or XML or the SqlClient provider for . NETCF to move data between the server and sqlite3 database. You can do snapshot replication to any ODBC data source.

But this might mean either copying your sqlite database to your server or finding another replication product which can go between SQLite and an ODBC desktop database. The last option I can think of is to switch from sqlite3 to sql mobile edition / sqlce or sql express (depending on if this is a device or something else) as you would have the option to set up replication or RDA (remote data access) between the those databases and your ms sql server 2005 db- hence the question are you married to sqlite3? Also- I just was reading about SQL Anywhere (ultralite) from Sybase which is a free solution.

This little database has a pretty small footprint and also support MobiLink Synchronization Wizard which allows you to setup replication with your MS 2005 db. Here is a moderately useful article about MobiLink Synchronization. If you decide to consider option 3 here are some articles to help set up RDA or Replication with your db's.

It's not plug-n-play but the Microsoft Sync Framework (msdn.microsoft.com/en-us/sync/bb736753) will do it. I've downloaded and installed the iPhone to SQL Server sync sample and run it. It's actually pretty slick, Works great.It was just a basic test but perhaps it will help you.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions