Migrate data and files from MSSql to MySql database

$250-750 USD

Closed

Posted

over 9 years ago

$250-750 USD

Paid on delivery

Budget = $300 We have a MSSQL database which powers a CRM system hosted on our local network. We had a developer migrate this database to our Mysql Sugar CRM database a few months ago however we can reach this guy any longer (no response from him). Because some time has passed during development the migration of data is out of date - we need to update our migrated data with the latest data held in the MSSQL database. We then need you to import the users, Contact, Accounts, Notes, Files, History etc all the data in the current crm into Sugar CRM. This task will involve the following: Step 1 - map all fields between mssql and mysql Step 2 - import all data and files related to the data/users step 3 - we will test the data step 4 - reimport the data so that we import all missing data between the test period. Payment will be made in 2 phases/milestones Milestone 1 = once you have created the import script and migrated the data Miestone 2 = once data is tested and confirmed as ok There are 2 key tables in the MSSQL contacts and person which will provide most of the data then the rest we will point out to you as required. looking forward to finding the right person for this job. Budget = $300

SQL

SugarCRM

Project ID: 7129078

About the project

24 proposals

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

24 freelancers are bidding on average $357 USD for this job

@marasinghe82

Dear Sir, Is this regarding same database structure on MS SQL and MySQL or different data base structures or same database structure ? Please share the data source backups. I can work using my environment and let you know the status. I'm very much familiar with MS SQL Server ( SSIS SSAS SSRS) and also during last five years I involved many project in ETL, data warehousing, BI reporting and six years of application development experience. I would highly appreciate if you assign this job to me and also I'm Microsoft Certified Technology Specialist (MCTS) for Microsoft SQL Server 2008 for Business Intelligence Development and Maintenance & Microsoft Office SharePoint Server Application Development. Please reply me for further details Best Regards, Jinesh

$300 USD in 10 days

5.0

(66 reviews)

5.7

@sswijaya

Hi, Let me help you with this project. I have more than 10 years experience with SQL database. I have worked on enterprise software using MSSQL and also data imports into various e-commerce system like OpenCart, CRELoaded, Shopify etc using MySQL database. I haven't worked with SugarCRM before, but I checked the documentation online and they provide the data dictionaries. I believe I can use this as reference to migrate your database. MySQL has database conversion wizard which we can use to import from MSSQL database. From there I can create a MySQL script to map all fields and migrate data into SugarCRM tables. This way the conversion process will be faster since all queries are done within same MySQL database. I agree with your budget and you can release the milestone after you receive and check the result. I estimate this could be done in about 5 days, depend on the number of tables and fields that need to be imported. Hopefully I can help you and I'm looking forward to have discussion. My time is GMT+7. Regards, Susanto

$300 USD in 10 days

5.0

(14 reviews)

4.6

@vnb400sl

Hello sir i can develop a script / spplication using .NET Framework (C# or VB.NET) to migrate the data and files from MSSQL to MySQL Will i be able to work offline Best regards vnb400

$311 USD in 20 days

4.6

(33 reviews)

4.9

@gopalvora

Hi I have gone through the details of your project and we find it well within our capabilities. I can create and deliver the project as per the information.I have skilled, expert programmers I'm very excited to assist you in making your Sites successful – please feel free to contact me directly to discuss this position further. Thanks Thanks

$515 USD in 10 days

4.8

(7 reviews)

4.3

@imian

Dear Sir/Madam, thanks for sharing your project. We (IT-Ally Services) are high quality web & software solution provider catering services to businesses across globe. Here are our proposal points for your reference: - Communication Skills - Fluent in written & spoken English. - Technical Skills set - Matches all the skills for this particular project. (SQL, SugarCRM) - Availability – Immediate - Project Deadline can be decided. - Will work on your project only and will apply all your requested business logics. - Will discuss all the milestones and timelines in detail. - Will generate the necessary weekly/daily reports and will be available for constant communication in order to achieve the highest quality standards. - All mentioned points this project description are agreeable and achievable. We have provided you a ballpark estimate here, and we will update our bid once we have a detail specification from you. Please provide the detail requirement in order to start working. We look forward to your positive response. Best Regards, Samar Shah IT-Ally Services "Let's Make IT Success"

$300 USD in 10 days

5.0

(3 reviews)

4.3

@pablotorres

am working on software development since 1992. I am expert on migration of databases, custom or general purpose. I can migrate any kind of relational databases with just few SQL sentences. I can solve problems about replacing or combining data related with plugins, modules, themes or components. I have a lot of linux server administrator skills. I have an strong knowledge of server side scripting, and client side. I can data scrape of webpages, normalize and populate into a system. The products are well documented. I deliver tested final products on my own server.

$555 USD in 3 days

5.0

(17 reviews)

4.1

@srinichal

I am an expert in delivering custom project and like to discuss further about the project needs .

$315 USD in 10 days

5.0

(3 reviews)

3.7

@andriy3s

Hi, I'm high rated coder from Ukraine. I've more than 12 years in the experiences of the database developing. My skills are includes MS SQL, PostgreSQL, SQLite, MySQL, MS Access, Sybase etc. Thanks, Andriy

$250 USD in 10 days

5.0

(14 reviews)

3.4

@RAlexM94

A proposal has not yet been provided

$300 USD in 10 days

4.8

(7 reviews)

3.3

@Zeldaze

Hi there, online and ready to get started ASAP. I have many years experience in data migration and server management. I am confident I can import the data from MSSQL to MySQL for you and verify the data is all in place as needed. Let me know. Thanks, James

$300 USD in 3 days

5.0

(5 reviews)

3.4

@igorssv

Hello I can help you with your project. I have an experience of working with MSSQL and MySQL datebase servers. So I think I can do this. I'd like to create python script to extract from one server and upload data to other server. Waiting for your response.

$299 USD in 5 days

5.0

(1 review)

2.7

@WebDevPro007

Talend Expert we collect more than 20.000 file / day from more than 150 differents sourcse (Oracle DB, MySQL DB, CSV, MSSQL ...) we transform the data and map it will the destination tables in our DATA WareHouse. We also perform some control : - Number of rows reed - Number of rows inserted into the destination table - Number of rows rejected are stored into a csv file for future analysis - all the logs : Start Time, End Time, Number of rows read, Number of rows rejected, .... are stored somewhere and analyse. Tools : Talend Open Studio (Free Version)

$300 USD in 2 days

5.0

(1 review)

2.4

@almase

Hello, I have 30 years of experience as system and database administrator. I have participated in multiple database migration projects. You can see several of then in my profile. In this moments, I have just fihised one of them expecting the OK from client testing. I suppose it is 2102 version of MSSQL and v5 of Mysql. Thanks

$305 USD in 3 days

5.0

(1 review)

2.4

@bicaig

Hello, My daily work is with data in different formats. I can provide you a way (program or script to migrate your data) Please give me the details and as soon as you will choose me I will start working. Best regards, Gabriel

$250 USD in 10 days

5.0

(1 review)

1.2

@aamirabbas111

Hi, We can do your job easily because we have high expertise in databases of all type like mssql, my sql, oracle etc etc Our major work and our clients are related to data analysis and manipulation . We already done the same nature of job many time ny transfering data from sql to oracle, oracle to my sql, mysql to mssql, ms sql to my sql etc We are ready to start work with you on trail basis and whenever you trust build up then we can continue . Looking for your sound response. Regards, Aamir Abbas

$250 USD in 5 days

0.0

(0 reviews)

0.0

@Armref

A proposal has not yet been provided

$526 USD in 10 days

0.0

(0 reviews)

0.0

@alfinus

Experince migrate data from mysql to oracle and oracle to oracle. Using Visual studio Using ODT Database of Nation Land Agency of Indonesia

$555 USD in 5 days

0.0

(0 reviews)

0.0

@jcsanchez1

I am very serious and formal worker. and I like to complete my work in time and form. I am very professional as person as worker, and I have experience working with database and i will do great work.

$277 USD in 20 days