6 Replies - 1416 Views - Last Post: 13 November 2013 - 10:01 AM Rate Topic: -----

#1 pvsk123   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 3
  • Joined: 12-November 13

Offline solution and data sync up

Posted 12 November 2013 - 07:53 AM

The requirement is given below;

Step 1 : User logs in to a system and download 5 lakhs records to his local machine (the system connects to a database located in a server - SQL Server database is the backend).
Step 2 : User disconnect from the network and he work on this local data. He will edit row by row and save it to his local machine. This process will go for weeks or even months. (currently the users are doing in excel - completely manual work - no storage - so we should get rid of excel usage)
Step 3 : User finishes editing all the 5 lakhs records and he is ready to sync it back to the remote database. He submits the data to the system again and the system has the capability to sync it back with its central or remote database.
Step 4 : When the next cycle comes user again download new set of data. Multiple users have to work on different set of records (we have an approach currently to handle security in manipulating data).

We are thinking of the below inputs for the solution;

- Winodws application is more suitable for this requirement considering the fact that in a web application also we need to deal with a local db which is challenging. Again we need some solid points to derive a conclusion (in terms of performance, mitigating the challenges in this particular requirement).
- With respect to downloading of data, we are thinking to have it in a local database and provide a solution so that the user can easily navigate record by record so that he can modify the details without connecting to the network.
- Need to look at how the same application can deal with local database.

Any suggestions on how to go with the solution?

Is This A Good Question/Topic? 0
  • +

Replies To: Offline solution and data sync up

#2 modi123_1   User is offline

  • Suitor #2
  • member icon



Reputation: 15679
  • View blog
  • Posts: 62,783
  • Joined: 12-June 08

Re: Offline solution and data sync up

Posted 12 November 2013 - 07:57 AM

Quote

Any suggestions on how to go with the solution?

Those look like okay ideas - what more do you need?

You may want to look at using a hosted database and the app connects to the db via a web service or api..
Was This Post Helpful? 0
  • +
  • -

#3 pvsk123   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 3
  • Joined: 12-November 13

Re: Offline solution and data sync up

Posted 12 November 2013 - 08:12 AM

When i say local database, is it possible to get into a conclusion with the below questions;

- Can we replicate the data in the local system without physically having a database. In HTML5 we can use indexDB concept.
- Is there a cache facility kind of thing we can achieve. Whenever we open the application offline it should be able to retrieve the cached data.
Was This Post Helpful? 0
  • +
  • -

#4 modi123_1   User is offline

  • Suitor #2
  • member icon



Reputation: 15679
  • View blog
  • Posts: 62,783
  • Joined: 12-June 08

Re: Offline solution and data sync up

Posted 12 November 2013 - 08:18 AM

.NET does have a multiple options for a local data storage: local db file, text file, etc.
Was This Post Helpful? 0
  • +
  • -

#5 optix212   User is offline

  • D.I.C Addict
  • member icon

Reputation: 30
  • View blog
  • Posts: 540
  • Joined: 10-October 09

Re: Offline solution and data sync up

Posted 12 November 2013 - 02:52 PM

I would honestly create an SQL compact database, fill a DataTable with the online databases content, fill the SQL compact database and DataGridView with your data table and then just save the Compact database with the new records. Before each sync I would just clear the local database.

If this way does not seem like a good way to go about it, then XML has always been a good friend of mine.

It all really just depends on what seems best for your workflow. From the information provided, there is no way of telling which solution would work best for you.

If you are doing your work on excel spreadsheets now, then you should look at the Microsoft.Office.Excel API and really decide if putting an import button for excel files is a good idea or not. It can really save you time since excel is a lot faster to use than a datagridview.
Was This Post Helpful? 0
  • +
  • -

#6 Skydiver   User is offline

  • Code herder
  • member icon

Reputation: 7354
  • View blog
  • Posts: 24,843
  • Joined: 05-May 12

Re: Offline solution and data sync up

Posted 12 November 2013 - 10:38 PM

SQL Server already has replication built in: http://technet.micro...y/ms152567.aspx

And replication between SQL Server and SQL Server Compact: http://technet.micro...v=sql.105).aspx
Was This Post Helpful? 0
  • +
  • -

#7 optix212   User is offline

  • D.I.C Addict
  • member icon

Reputation: 30
  • View blog
  • Posts: 540
  • Joined: 10-October 09

Re: Offline solution and data sync up

Posted 13 November 2013 - 10:01 AM

I honestly didn't know what replication was until I read that last post. I went out and found a decent article on the matter. Also, the guy was kind enough to create his own library for easy replication. The demo is here.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1