Windows Phone synchronize with SQL Server 2014

  • Congratulations for the site!

    I'm new to developing Windows Phone applications, need to know which is the best alternative to work offline (LocalDb), synchronize and update a database in SQL Server 2014.

    You me you can suggest links to web sites of reading.

    Thank you

  • gonzalezfa (7/17/2015)


    Congratulations for the site!

    I'm new to developing Windows Phone applications, need to know which is the best alternative to work offline (LocalDb), synchronize and update a database in SQL Server 2014.

    You me you can suggest links to web sites of reading.

    Thank you

    What is best for a given app is highly dependent on what the app is expected to do. Any time you expect to move data outside of the phone's Windows OS to somewhere else (or vice versa), the network between the two is going to be the bottleneck, and you'll need to know what kind of bandwidth you have to make an intelligent choice about how to best handle data transfers. For example, if you write a game app, and need to transfer large graphics files, that might not be practical as an in-game, or "on the fly" feature. There's no one-size fits all solution here.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • gonzalezfa (7/17/2015)


    Congratulations for the site!

    I'm new to developing Windows Phone applications, need to know which is the best alternative to work offline (LocalDb), synchronize and update a database in SQL Server 2014.

    You me you can suggest links to web sites of reading.

    Thank you

    Also, most Windows Phone environments are seriously short on RAM, and running SQL Server there might be a serious stretch. What are you trying to accomplish?

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • Hi Steve,

    the amount of data to synchronize is small, but it should enable work offline application for lack of cell phone coverage. And then synchronize the data similar to SQL Compact 3.5 later.

    Thank you

  • gonzalezfa (7/28/2015)


    Hi Steve,

    the amount of data to synchronize is small, but it should enable work offline application for lack of cell phone coverage. And then synchronize the data similar to SQL Compact 3.5 later.

    Thank you

    You still haven't provided an "objective". Assuming you get some form of SQL Server Compact Edition on the Windows Phone, what then ? What's the goal? What do you want to have happen? You talk about a small amount of data to "synchronize", but provide no detail on just how much data we're talking about, or the nature of the data, nor do you provide any reasoning on why there's a need to synchronize it with a SQL 2014 instance. And then you want best practices? Best practices for what, exactly? As so many of the "online games" that are in the "APP" space on cell phones in general quite likely synchronize their data with various differing platforms, there may not be much beyond the inherent security of the connectivity to which to apply any best practices. And, I might add, a "Windows" phone is no more (or less) secure than a Windows PC or tablet. You need to define a detailed and specific objective before you can worry about best practices.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • First that nothing apologies for my English.

    The application in the cell aims to facilitate transcription of the data and minimize manual office transcription errors when reading a form.

    Our technical staff should be checked on the client each stations traps insects depending on plane and its bar code. You must get a picture, mark the amount of captured insects and fill the amount of added product.

    The application must work offline because there is no cellular coverage in some basements of buildings, or they are in a rural town.

    The current database is in SQL Server and you want to synchronize both ways data of Id station, type of insect, number, photo and added product quantity.

    Another requirement is that a client can be visited by several technicians and on every Smartphone must download all data from the stations and at the end of each Smartphone synchronizes with SQL Server to check if all stations and that customer data are complete.

    It is required to be a small handheld device, easy to use.

    Thank you for your understanding and help

  • gonzalezfa (7/28/2015)


    First that nothing apologies for my English.

    The application in the cell aims to facilitate transcription of the data and minimize manual office transcription errors when reading a form.

    Our technical staff should be checked on the client each stations traps insects depending on plane and its bar code. You must get a picture, mark the amount of captured insects and fill the amount of added product.

    The application must work offline because there is no cellular coverage in some basements of buildings, or they are in a rural town.

    The current database is in SQL Server and you want to synchronize both ways data of Id station, type of insect, number, photo and added product quantity.

    Another requirement is that a client can be visited by several technicians and on every Smartphone must download all data from the stations and at the end of each Smartphone synchronizes with SQL Server to check if all stations and that customer data are complete.

    It is required to be a small handheld device, easy to use.

    Thank you for your understanding and help

    I think you'll be more dependent on the type of connectivity you can get. Assuming that you can use the SQL Native Client for connectivity, basic ADO code within VB,Net should allow you to create a .NET Windows Forms App that could run on the Windows phone, with menus to select which operation to perform. You'd also need some kind of local database, either SQL Server Compact Edition (I have no idea what version of that is available), or some other database that fits on a Windows phone and is reliable, and can be accessed in VB code. Whether or not it's SQL Server isn't necessarily critical, and given that you need to store photos, you need a database that's capable of at least storing a file system path and filename, if not the photo itself, although be careful, as photos taken by the user, even of an insect, can be several megabytes in size, which could be problematic if kept in the database... you may be better off standardizing the photo for a given insect and including any updates to the "standard list" as part of the synch process. Does any of that help?

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply