I have a sales database to replicate in a SQL Server.
There are 3 tables to be created in the SQL Server and actions will be:
+/- 10 fields and [url removed, login to view] records
1 Delete data in SQL Server and load (starting from an ID) - on demand
2 Check the last ID in SQL Server database and in original, based on this, delete the last 20 records and re-load and load additional new records - automatically (scheduled task or similar)
+/- [url removed, login to view] records and 20 fields
Idem as in table #1
+/- 3 fields and [url removed, login to view] records
Idem as task 1 - automatically (scheduled task or similar)
Conection with original database will be via ODBC. This must be a parameter. You will work in your PC and I will make client instalation.
Parameters and link to original database can be done via MsAccess, this is working very fast now, you can use it as a bridge.
You will configure Index for fast Querying.
Code must be open. I will read it (with your help). You should be able to provide future support on hour basys.
56 freelancers are bidding on average $113 for this job
I am expertise in c# and sql server 2005/08. I am expertise in store/ purchase and inventory domain.I had made 4-5 ERP project which automate their sales/purchase and inventory works.