MySQL to MSSQL product data conversion
- or -
Post a project like this2155
£150(approx. $188)
- Posted:
- Proposals: 10
- Remote
- #2014518
- Awarded
Block Chain expert, Mobile app developer, web developer, nodejs and reactjs, Digital Marketing
Pune
164609210119018274756480472604819890212058333206265021226812231645
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
We have product data for clothing that comes to us as MySQL database and some Excel spreadsheets that we need converting into a specific MSSQL format.
The MySQL data needs reformatting to the new scheme. We already have a MySQL cursor and saved queries to convert the data to the new format but they could be better and quicker. Could be used as a good starting point. See attached file.
As this is a product update the existing MSSQL data will be supplied. Categories and product rating data will need to be kept.
The final data will need to be supplied as MSSQL queries that we can run on a Windows 2008 SQL installation to insert the data.
The MySQL data needs reformatting to the new scheme. We already have a MySQL cursor and saved queries to convert the data to the new format but they could be better and quicker. Could be used as a good starting point. See attached file.
As this is a product update the existing MSSQL data will be supplied. Categories and product rating data will need to be kept.
The final data will need to be supplied as MSSQL queries that we can run on a Windows 2008 SQL installation to insert the data.
Paul L.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
5 Nov 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Paul,
There are few tables that are used in queries but we didn't see the create statement for them.
Are you available for a quick discussion so that i can suggest you a better solution.
Regards,
Dharmesh
644928
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies