Closed

Port 2 SQL Files From MySQL to PostgreSQL

This project was awarded to expertcoder1vw for £80 GBP.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
£20 - £250 GBP
Total Bids
11
Project Description

Description:
This project involves porting 2 files written in the MySQL flavour of SQL to the PostgreSQL flavour of SQL. “[url removed, login to view]” is a small SQL file that creates a couple of user accounts. “[url removed, login to view]” is a larger SQL file that creates 71 tables, 47 views and 131 stored procedures. This might sound like a lot but the views and stored procedures are all pretty simple. Both these SQL files were generated by MySQL Workbench 5.2. The requirement is that they be
modified to be compatible with PostGreSQL 9.2.

Required Deliverables:
An equivalent version of [url removed, login to view] that can be applied to a PostGreSQL database using something like pgAdmin..
An equivalent version of [url removed, login to view] that can be applied to a PostGreSQL database using something like pgAdmin.

Further Information:
The database generated from these SQL files is accessed from a C# WPF application written using Visual Studio 2010. I can provide a sample application showing the use of one of the views and stored procedures if that would help. This is our first posted project. We would like to reassure bidders that we are an established UK company, with over 15 years experience developing bespoke software for our UK clients.

Full payment will be made once the two correctly modified SQL files have been delivered. We will not consider making milestone payments on this project

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online