In Progress

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: 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, 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, macro conversion, script run access sql, access vba sql server

About the Employer:
( 0 reviews ) banhaa, Egypt

Project ID: #1274771

Awarded to:

dkirby9172

Hello- I have several years experience executing scripts just as you describe in your posting. Please see PMB for a more detailed approach. Thanks, Dave

$225 USD in 2 days
(1 Review)
3.3

19 freelancers are bidding on average $195 for this job

marasinghe82

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

$30 USD in 1 day
(61 Reviews)
5.5
vhegz218

I am an IT professional and I have done this kind of procedure several times with different instances. Please read PM.

$100 USD in 1 day
(3 Reviews)
4.0
guevanjr

Please consider my bid. Thanks, SG

$80 USD in 2 days
(6 Reviews)
3.4
VVladimir

Proposal for the processing rules, refer to the PMB

$200 USD in 2 days
(6 Reviews)
2.5
iosifrn

Hello, I would use VBA with a form that would report the transfer progress - number of records source/destination if fails error description for specific step and reimport option from any step. I have over 15 years o More

$200 USD in 5 days
(1 Review)
1.0
AhmedEj

hello. I can do this for you. contact me thanks

$40 USD in 1 day
(0 Reviews)
0.0
NewFreelan

I have very good knowledge in MS access and SQL server.

$75 USD in 2 days
(0 Reviews)
0.0
pramodv

I have done work of data migration from vfp database to ms sql server.

$160 USD in 8 days
(0 Reviews)
0.0
snehashisgh

I use scrip for this project. Pls. give me the project. I have last 6+ yrs. experience in development.

$150 USD in 3 days
(0 Reviews)
0.0
pemineal

My last experience was a migration from SQL 2000 to SQL2005 with more than 200.000 records.Working MSAccess + 10 years. Pedro Alves.

$200 USD in 2 days
(0 Reviews)
0.0
rkrishnaprasadh

Dear Sir, I am PG in CS with 10+ exp in SW dev. Kindly refer to private message for more details as requested by you. Regards, RKP

$200 USD in 1 day
(0 Reviews)
0.0
cwcooley

I have done this type of project many times and should able to complete it same day. If there is a significant amount of problem data that won't transfer, I might need a day or two to get it over manually. Either way, More

$200 USD in 2 days
(0 Reviews)
0.0
junbest1986

I am a computer programmer since 2008, I have an experience about this, please see PMB

$150 USD in 2 days
(0 Reviews)
0.0
blackrainbow

Hello there, Ready to start. Check PMB

$600 USD in 1 day
(0 Reviews)
0.0
alconarain123

experience will be shown in my work.i can work with you. plz check your PM.

$100 USD in 6 days
(0 Reviews)
0.0
doonsoftwares

************* Ready to start, have experience in data migration between MSACCESS and MSSQL, please check PM for more details *************

$400 USD in 5 days
(0 Reviews)
0.0
kfanx

I am an expert on microsoft sql server and access. Since the discrepancy on data integrity and schema. A bid price is a bit higher. Please understand. Thanks!

$500 USD in 30 days
(0 Reviews)
0.0
zaffarsaffee

dear, currently i am doing a job that involves a lot of ms-access data, vb apps(desktop)and sql. being more specifically i am doing a job where a big organization gets different types of Identity cards..doing same ..wh More

$90 USD in 3 days
(0 Reviews)
0.0