In Progress

SQL Server data insert/data update

Hello

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:

Table 1

+/- 10 fields and [url removed, login to view] records

Task:

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)

Table 2

+/- [url removed, login to view] records and 20 fields

Task

Idem as in table #1

Table 3

+/- 3 fields and [url removed, login to view] records

Task

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.

Tanks

Skills: .NET, C# Programming, Microsoft Access, SQL, Visual Basic

See more: sql insert, sql update, task data update, data insert sql server, insert sql server, update insert sql, starting visual basic, sql server data insert, task replicate, sql support, sql code, sql based, server support, server load, server configure, data visual, data tables, sql created, link sql, update code sql, odbc code, net server client, replicate index, sql insert net, configure odbc

About the Employer:
( 67 reviews ) Silla, Spain

Project ID: #1264835

Awarded to:

hia8cn

Hello, I am Sr. database engineer from China. Now I work on big software company in China. I did the similar solution for your requirement. For task1: Delete data in SQL Server and load (starting from an ID) More

$100 USD in 3 days
(1 Review)
3.1

56 freelancers are bidding on average $113 for this job

sandymra

MS Access developer with more than 7 years experience.

$155 USD in 5 days
(54 Reviews)
6.5
usamacpp

Easy task. Please check PMB for more details.

$120 USD in 5 days
(39 Reviews)
6.0
manhpham

I am sure I can do this project quickly.

$80 USD in 2 days
(29 Reviews)
4.8
tuyenvt

I can do it,Please see my profile for details.Thanks

$90 USD in 3 days
(12 Reviews)
4.6
tonykim100

I am ready to start now.

$100 USD in 1 day
(18 Reviews)
4.5
DeoTech

Hi! I work with MS Access and MS SQL since 1999. I know how they work via ODBC. Regards.

$100 USD in 7 days
(6 Reviews)
4.1
thequyen

Hi, I'm very excited about this project. Hopefully soon be able to participate !

$90 USD in 1 day
(5 Reviews)
3.2
sriv151

Please have look into pmb

$250 USD in 5 days
(3 Reviews)
2.5
ferdoush123

Let me do the work for you. I have more than 6 years experience on database.

$65 USD in 3 days
(1 Review)
2.4
iosifrn

Hello, I have over 15 years of programming experience in MS Access, SQL Server, ORACLE, C#, Visual Basic, VBA, ASP.NET, Web Development and others. I can help you with this project and any other projects you may have. More

$150 USD in 3 days
(1 Review)
1.0
gemleo

i can do this for you

$50 USD in 3 days
(1 Review)
1.4
gauravsharma88

Ready for your job

$250 USD in 30 days
(0 Reviews)
0.0
simsun007

This project can be done effectively and efficiently,so please feel free to contact me anytime. Thnx..

$150 USD in 5 days
(0 Reviews)
0.0
dtnayomi

I can do this

$150 USD in 10 days
(0 Reviews)
0.0
lanticsudharsan

Hai Our company name is “LANTIC”.we have seen the details of your project. We can fulfill your requirement. We are using SQL Server for database maintainence.we are using ASP with C# coding. We are using advanced More

$30 USD in 25 days
(0 Reviews)
0.0
hamidawan

Hi I'm an expert database developer. I can do this task for you Please contact me Regards

$100 USD in 2 days
(0 Reviews)
0.0
vempallimadhan

I have good experience in SQl Server Development

$70 USD in 3 days
(0 Reviews)
0.0
NkDeveloper

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.

$150 USD in 10 days
(0 Reviews)
0.0
BALAJIRR

i understood ur project give the sample database to me i can do it in one day ;if u interested just contact me

$30 USD in 1 day
(0 Reviews)
0.0
UmakantaSwain

I can do it for you. Please refer me.

$30 USD in 7 days
(0 Reviews)
0.0