176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Data migration & mapping to new table structure
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Feb 27, 2013

Bidding period extended.

Feb 25, 2013
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Wed, Feb 13, 2013
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

I have 3 data sources:
1/ Excel sheet
2/ MS Works DB
3/ Access database

All 3 need mapping to a new MS SQL Relational Database. I will provide this schema as the target.

#1 & #2 are flat files where columns can be mapped to the new fields but need to split to relational table and maintain their ID link.
#3 is an existing access database that has a similar relational structure however the tables have been renamed and the columns renamed.

I will provide sample tables and fake records (demonstrating scenarios) for suitable applicants. However, I cannot provide the final data.

To meet the criteria for me to share this with you I need to hear your approach to this data migration (i.e what tools you may apply)

Due to the confidential nature of the data, I will need to be able to run the scripts or tools on my side. If a tool is used then I need to be able to access this free or cheaply to perform the runs. (eg: RedGate trial)

OLE or ODBC with coded scripts are an acceptable o...

Sign in or Register to see more

Job ID: 37823930
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 India  |  
Data Modeling, Developing ETL Scripts in Talend, Talend Scripts turning, Database Administration for mysql and SQL sqlserver, Java OLAP CUBE...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 38344273  |  Submitted: Feb 26, 2013 12:18 ET 
Proposal SEALED

Vikram T.      
Vikram T.'s identity has been verified.  Learn More
 India  |  
-- Certified Talend Open Studio Data Integration Consultant -- 5 Star Rating in all Projects -- 250+ Elance Hours -- 1000+ Other freelance Hours...
4
  |  
 5.0   |  Private   |  4 Jobs
Bid ID: 37951531  |  Submitted: Feb 16, 2013 09:19 ET 
Proposal SEALED

 India  |  
INVITED
I promise to provide you premium quality, value for money and prompt service for all your Excel / PowerPoint / SQL server based requirements If...
5
  |  
 4.8   |  $2,882 Earnings   |  48 Jobs
Bid ID: 37891985  |  Submitted: Feb 14, 2013 14:23 ET 
Proposal SEALED

 India  |  
Expert in perl, Data processing , data manipulation, web data extraction and interaction Web data scraping Geo data extraction and processing Excel...
6
  |  
 4.9   |  Private   |  25 Jobs
Bid ID: 37890285  |  Submitted: Feb 14, 2013 13:31 ET 
Proposal SEALED

Slobodan K.      
Slobodan K.'s identity has been verified.  Learn More
 Bosnia and Herzegovina  |  
Main field of my work is VB.NET for desktop and PHP & ASP.NET for web applications (It's mostly with MSSQL and MySQL database) I can make desktop...
3
  |  
 5.0   |  Private   |  9 Jobs
Bid ID: 37882088  |  Submitted: Feb 14, 2013 09:36 ET 
Proposal SEALED

We have extensive experience in Java with around 11 years of experience. During my career I have worked for several Fortune 500 companies like GE...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 37867676  |  Submitted: Feb 14, 2013 01:28 ET 
Proposal SEALED

 China  |  
- Boost Performance(Server Optimization, SQL Tuning, Migration) - Data Auditing. - Data Modeling, DB Design, Reverse Engineering - Data Quality...
6
  |  
 4.8   |  Private   |  21 Jobs
Bid ID: 37847781  |  Submitted: Feb 13, 2013 13:10 ET 
Proposal SEALED

Olga Vojinovic      
Olga Vojinovic's identity has been verified.  Learn More
 Montenegro  |  
Supervised,coordinated and was part of the team in the following projects which resulted a completely new products: ADMIS - Documents processing...
4
  |  
 5.0   |  Private   |  0 Jobs
Bid ID: 37839185  |  Submitted: Feb 13, 2013 09:41 ET 
Proposal SEALED

ABS
 India  |  
ABS is a full fledged digital marketing and Wordpress web development company founded in year 2008, we have provided quality service in Elance for...
8
  |  
 4.9   |  Private   |  56 Jobs
Bid ID: 37838047  |  Submitted: Feb 13, 2013 09:07 ET 
Proposal SEALED

 Greece  |  
Software developer with 7 years team based commercial .NET experience and 10+ years Microsoft development experience. Cutting edge experience in...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 37837793  |  Submitted: Feb 13, 2013 08:59 ET 
Proposal SEALED

Dmitry Tarasov      
Dmitry Tarasov's identity has been verified.  Learn More
 Ukraine  |  
Researching and produce solutions for various MS SQL DataBase tasks. All jobs from maintenance to developing. 6 years experience.
2
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 37836121  |  Submitted: Feb 13, 2013 08:09 ET 
Proposal SEALED

 Egypt  |  
Hi, I am already studied and worked a lot with Databases! SQL server 2005 and writing queries. It's an experience for 4 years. I'm a good writer...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 37836101  |  Submitted: Feb 13, 2013 08:08 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »