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.
Hello, as there have been many questions, I will try to clarify.
The original data is in a database wich can be read using ODBC conection.
The destiny will be a SQL Server database.
First of all, you will create the tables and Index in SQL Server. I can provide the structure and records in a mdb file.
Second, and this is the core task, I need you to update data in SQL Server (you will read the original database and update the destiny database). See original description in my project.
We have Office 2010 installed, SQL Server 2000, .net 4, Windows server 2003 R2.
I don't know about programing tools, i am used to read VBA code. you can use Visual Studio? something different?
I need to understand your code, so It must be open. You will tell me how to read it, which tool do I need. I am not programmer, you should be able to suport me on hour basys or future projects.
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.