sqlsaturday #311 sofia - databases for mobile
DESCRIPTION
This presentation want to answer to two common mobile developer questions. What databases I can use on mobile devices, and how simply to synchronize the data from that database with my SQL Server. The demos are based on Windows Embedded Handheld (6.5.3, or on the WE8.1HH version), but the majority of the methods of data synchronization would work on other platforms also.TRANSCRIPT
Databases for Mobile
Sponsors
About me
Catalin Gheorghiu
I Computer Solutions
3 |
Agenda
Why we are talking about it The ropes SQL Compact Merge Replication Azure Mobile Services Azure Mobile Services with offline capabilities Zumero How about PhoneGap? Q&A
4 |
Why we are talking about it
The problem we try to address
5 |
SQL Compact Merge Replication
The problem we try to address
6 |
DEMO
SQL Compact Merge Replication on Windows Server 2012 R2 & SQL Server 2012 R2
Tip
SSCE_M_IDENTITYRANGE, "Internal error: The identity range was not established"."If you experience any errors that have the prefix "Internal error" when you use SQL Server Compact 3.5, try the operation again as the error might not reproduce. If the error appears again, you should immediately contact Microsoft Product Support Services. The internal errors cannot be resolved by common
troubleshooting techniques.
DEMO
Azure Mobile Services
DEMO
Azure Mobile Services offline data handling
Zumero
WTF?
11 |
DEMO
Zumero
How about PhoneGap?
DBs on PhoneGap
13 |
Resources
http://technet.microsoft.com/en-us/library/ms171908(v=sql.90).aspx
http://java.dzone.com/articles/merge-replication-sql-server
http://azure.microsoft.com/en-us/documentation/articles/mobile-services-windows-store-dotnet-handling-conflicts-offline-data/
http://dotnet.dzone.com/articles/alternative-merge-replication
http://docs.phonegap.com/en/edge/cordova_storage_storage.md.html#Storage
14 |
Q&A and contact info
• My Blog http://ronua.ro/blog • My Email
Sponsors