Merge 17 identifical access DBs into SQL Server

Closed

Description

Hi

I have a Microsoft Access database with nearly 10 years worth of data. Over the years we have taken copies of the database and purged the old data as Access was having trouble with corruption. We have designed a new SQL Server database and would like to move all of our old data into the new database. You job is to:

1. Write a script to move the manifest and sales data from 17 identitical Access DBs into SQL server IN out new format - I will provide SQL DB and diagram

2. Move ALL the data and REMOVE duplicates - the copies of access have duplication

3. Develop a report or two proving that we have properly moved over all the data without duplication or missing some days. (GROUP BY and COUNT on DATE FIELD etc.)

More information:

Suggested approach

1. The Access database has two main tables which will need to be moved into SQL: Manifest, and Sales.

2. It might be better to create a query connecting a couple of the related foreign keys into the table so you can just have two tables in SQL with the foreign data included.

3. I suggest using SQL Migration Assistant to move these tables and all the data over into SQL, repeat for all 17 databases, and clean up duplicates removing problems.

4. Once you have the data in SQL, do up a quick group by report to see if you have all the data across without duplicates. The data is for a dive boat passenger records and sales. Each day should have between 50-100 passengers. Finding the duplicates should be easy enough.

5. Once you have the SQL data correct, write a SQL script to migrate the data from your simple 2 table SQL server tables and put the data into our new database format. I will provide the schema and a mapping of the data for you. This will involve some manipulation.

6. I will provide all the Access database files by sharing a dropbox folder. Total size 480MB

7. I will be available to answer questions on mapping and database schema. etc.

Thanks,

Dave

Skills: Data Mining, Data Processing, Microsoft Access, SQL

See more: sql server merge data, identifical, access sql merge, write for finding a job, sales folder, microsoft access job, finding a new job, access group, sql server or, sql server job, sql microsoft access, microsoft access sql, job mapping, sql script, sql duplicates, sql data, passenger, move sql, microsoft sql server, merge data, manifest, dive, data merge, script move files dropbox, sql table remove

Project ID: #4743964

Awarded to:

CodeAmbassador

Hi Dave, I'd like to help you on this. Please see your PMB for how I'd approach this to guarantee that the import is being done correctly. regards, J.

$315 USD in 3 days
(19 Reviews)
6.1

19 freelancers are bidding on average $237 for this job

sonarkaushik

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$194 USD in 5 days
(22 Reviews)
4.9
sswijaya

Hi, let me help you with this project.

$111 USD in 7 days
(21 Reviews)
4.2
daveclary

Good evening. Just got done importing 250 gb of US Census data into SQL. Ready to do some more data migration projects. It looks like you have mapped your data well. You did not specify if your database is SQL 2008 or More

$166 USD in 3 days
(7 Reviews)
3.6
AccuPro

Hello, I can help.

$222 USD in 5 days
(3 Reviews)
3.3
OrionConsulting

David, I have 25 years of experience working with MS SQL Server. I have done data loading, cleansing, and de-duping on many databases in my career. I have also worked with MS-Access, too. You have obviously put a lot More

$236 USD in 5 days
(3 Reviews)
2.9
manjusha02

Shall we start now?

$244 USD in 5 days
(2 Reviews)
2.7
nitishthelegend

Hey, I can help you merge your 17 SQL files!

$222 USD in 3 days
(1 Review)
1.9
PigtailXL

Experience and seriousness here. I can do this project. Please, read the message I've sent. Thanks.

$200 USD in 7 days
(7 Reviews)
1.9
jwbart10

I am an awesome Senior SQL Server Developer. I would be glad to unhinge you from the clutches of Microsoft Access.

$222 USD in 3 days
(1 Review)
1.8
cfitchett

I have extensive experience with Data Conversion from MS Access and other database systems into MSSQL. I've been doing this type of work for 10+ years. The approach you outlined sounds straight forward and I would fo More

$222 USD in 3 days
(0 Reviews)
0.0
MichalNo

I am interested in the implementation of this interesting project.

$240 USD in 7 days
(0 Reviews)
0.0
tjd1

I have 10 years of experience with MSSQL from SQL Server 7 through 2012. Have done a number of data migrations with and without transformations of the data. What version of SQL Server are you using? Please note that More

$250 USD in 7 days
(0 Reviews)
0.0
srinivasanrajan

Hi, I have 15 years experience in IT domain and more than 10 years in MS SQL server. Access, .Net, Crystal Reports. I have done many data migrations like Accounting Software data. Inventory Control, Retain, etc Rega More

$277 USD in 7 days
(0 Reviews)
0.0
YourSoftSol1

I have recently worked on a similar kind of project and i ready to go ahead with this.

$200 USD in 4 days
(0 Reviews)
0.0
reflX

Hi Dave, Please see more details regarding my suggested solution in your private inbox Regards

$200 USD in 7 days
(0 Reviews)
0.0
PETERCKENT

UK Based. Very experienced

$155 USD in 3 days
(0 Reviews)
0.4
gianpaolo

Please check PMB

$666 USD in 10 days
(0 Reviews)
0.0
mrsh3757

My 15 years of IT experience in Data Modelling, Database design, Data Profiling, Data Quality, Data Consolidation, Data de-duplication, Data Migration, Data matching and Merging implementing pure custom and product bas More

$155 USD in 5 days
(0 Reviews)
0.0