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

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.

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

See more: sql insert, sql update, sql insert insert, task data update, data insert sql server, insert sql server, update insert sql, starting with visual basic, sql server data insert, sql server or, task to replicate, sql support, SQL Server, sql server c, sql odbc, Sql code, sql based, server support, server load, server configure, net sql server, net c# sql server, data visual, Data tables, configure server

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 [url removed, login to view]

$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 [url removed, login to view] 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