Cancelled

Transfer data from MS Access97 dB into SQLServer dB

We have an old database in MS Access 97 containing data on customers of our business (names, addresses, purchases etc). We need to transfer this data to a new SQL Server 2008 database. Both the old and the new database have about 30-40 tables each.

The old and the new database are for the same purpose, but they have different structure. We cannot map the whole tables accross, instead the fields/columns of tables need to be individually mapped accross.

From this project we want to get an automatic conversion program:

1) we would help you map the fields/columns between the two databases,

2) you would create either a SQL Server Procedure, or a SQL Server Script, or a VBA macro in MS Access,

3) we would run this processor program,

4) you would manually fix any irregularities in the data to complete the data transfer.

All data must be transferred, no data can be left behind. Therefore, no matter how good your data transfer program is, you may have to fix manually any anomalies in data.

To get this project, you need to either show that you have done something very similar before, or that you have excellent knowledge of both MS Access and SQL Server.

Please describe in PM how you would accomplish this task: would you use VBA, SP or Script. Convince me that you got a good approach and you got this project.

This project must be completed by Friday 4 November.

Skills: Data Processing, Microsoft Access, SQL

See more: sql 2008, use data structure, tables data structure, sql data conversion, new data structure, ms processing, got transferred, data conversion sql, database processor, map data structure, automatic data processing, accomplish business, access97, access transfer data, would describe, get sql help, excellent data, data transfer, data tables, sql server 2008 access, data processing vba, access vba program, vba help, vba data processing, project data structure program

About the Employer:
( 14 reviews ) Surry Hills, Australia

Project ID: #1266250

97 freelancers are bidding on average $171 for this job

HussienSharaf

HI, I have a tool for mapping fields from one table to fields of another table. Some mapping SQLs might need to be manually edited in case of mapping fields of more than one table to a single target table. Plz check More

$250 USD in 3 days
(43 Reviews)
6.7
eperfections

I have done similar jobs few times before. Please see PMB for details.

$250 USD in 5 days
(76 Reviews)
5.9
MattThrower

I have 8 years experience in both access and SQL.

$90 USD in 4 days
(16 Reviews)
5.2
marasinghe82

Dear Sir, I'm very much familiar with MS SQL Server ( SSIS SSAS SSRS) and also during last three years I involved many project in ETL, data warehousing, BI reporting and five years of application development experie More

$30 USD in 1 day
(29 Reviews)
4.6
ExactSystems

I have few questions.Please see detail on PMB. Regards

$250 USD in 5 days
(4 Reviews)
4.4
GediminasB

I am old MS SQL programmer working with these databases over 10 years. I shall create project for Integration Services and you will be able to import data in place. I shall import data that you‘ll present me and shal More

$150 USD in 3 days
(3 Reviews)
4.5
rodelacidera

Hi, I'm expert in database conversion.Please check PMB for more details. regards

$90 USD in 3 days
(3 Reviews)
4.2
ifaisal

Hello I can do this for you. I have plenty of experience in both MS Access and SQL Server. Please see my private message for more details. Regards

$150 USD in 10 days
(10 Reviews)
4.2
bldroid

Highly experienced .NET/MSSQL developer and software architect. I can write you code in C# and create a Windows app to transfer the data with row-by-row validation.

$150 USD in 3 days
(7 Reviews)
4.2
vhegz218

I am an IT professional and have experienced this kind of job. Please check PM.

$30 USD in 0 days
(3 Reviews)
4.0
mars8246

Hello, Sir. I have many experiances of Access management using VBA and .NET office runtime as well as SQL server programming using .NET. I am going to do your work using .NET since .NET can enable me to read data More

$120 USD in 3 days
(3 Reviews)
3.9
momo2619

Dear Sir, Please Read your PM. Thanks Meena

$100 USD in 1 day
(12 Reviews)
3.7
yehia111111

Hi,Kindly check your PM

$140 USD in 4 days
(4 Reviews)
3.7
kci

Hello there, I have extensive experience with databases, but I'm sure you hear that all the time :) Check your PM I will try to paint a clearer picture. Cheers

$88 USD in 2 days
(2 Reviews)
3.5
shacoim

Hi, I have good idea. Please check PM.

$75 USD in 2 days
(10 Reviews)
3.5
guevanjr

Please consider my bid. Thanks.

$100 USD in 2 days
(6 Reviews)
3.4
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. I have done a DEMO script. Please check the PM. Thanks, hia8cn

$150 USD in 5 days
(1 Review)
3.1
intechwebworks

Hello Sir I am ready to implement this.Please Check you pmb for details Thankyou

$200 USD in 5 days
(2 Reviews)
2.3
phobosq

Hi, an experienced MS SQL Server DBA (MCTS/MCITP SQL Server 2005), happy to help. Please check your PMB.

$250 USD in 5 days
(1 Review)
2.0
freeagent11

please see pmb. thanks.

$45 USD in 2 days
(1 Review)
1.8