176985602337900

Find freelancers. Lose those costly delays.

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

or, Register with Elance »

SSIS Project: Dataflow Task To Replicate MySQL tables to SQL Server
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.

Jul 3, 2011
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Thu, Jun 30, 2011
  • 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
  • U.S. freelancers must have W9
Sign in to view client's details

Operating System: Windows Server 2003 x64
Source Data: MySQL 5.0/5.1
Target Data SQL Server 2005

Should be developed on and must run in x64 environment
Other versions of operating systems/databases will not be accepted
Attached are DDL of the source tables that will be used (among others)

Description of operations:
1. Truncate Target Tables
2. Migrate Data from Source to Target
3. Error flow should email a test recipient (we can modify later)

Finished solution will contain:
Project file
Source database with sample data
Target Database
Instructions on running solution from command line on target O/S
------------------------------------------
Added 1 JUL 2011, 15:44 PM EDT
And additional requirement/clarification:

The target data types must match as closely as possible the source data types. The match doesn't need to be exact, but it should maintain its reportability/queryability.

So, an int can go from one type of int into another, but a date/time field can not go into a te...

Sign in or Register to see more

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

 Morocco  |  
Software engineer with 6 years experience in the development of service oriented applications and BI solutions using the latest Microsoft...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 25004678  |  Submitted: Jul 2, 2011 21:45 ET 
Proposal SEALED

Sereena Kurunkadan      
Sereena Kurunkadan's identity has been verified.  Learn More
 India  |  
I have my expertise in developing web and desktop application/database ,maintenance and support ,Database administration and Windows Azure .
2
  |  
 0.0   |  $0 Earnings   |  0 Jobs   |  1 verified credential(s)
Bid ID: 25003110  |  Submitted: Jul 2, 2011 16:15 ET 
Proposal SEALED

RAJAN PATEL      
RAJAN PATEL's identity has been verified.  Learn More
 India  |  
Over the last 8 Years, I had been providing excellent service in MS SQL Server Development & Maintenance for Development, QA, Staging, Production...
2
  |  
 5.0   |  $50 Earnings   |  1 Jobs
Bid ID: 24985097  |  Submitted: Jul 1, 2011 06:20 ET 
Proposal SEALED

 India  |  
We are a MS Certified Business Intelligence developer / provider with 10 years proven experience in BI and Data Warehousing areas. An expertise in...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 24980561  |  Submitted: Jun 30, 2011 23:45 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 »