Port 2 SQL Files From MySQL to PostgreSQL

Budget £20 - £250 GBP
Bids 11
Average Bid £105

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

Post a Project Like This

This project was awarded to

expertcoder1vw

Steve is an excellent programmer. He completed the work quickly and as specified. He communicated with me throughout the process to make sure that I was satisfied. I will definitely hire him again for future jobs.
About the Freelancer
expertcoder1vw Profile Picture

I am an experienced coder with over 19 years of coding experience in Foxpro, VB6, MS-Access, C# / VB.NET , Delphi, MySQL, MS-SQL Server, Oracle, Sybase Advantage and Firebird. Specialist in Windows database application software development. I offer to develop high quality applications at reasonable prices for even the most discerning buyers. Areas of Expertise: Foxpro, VB6, MS-Access, C# / VB.NET , Delphi, MySQL, MS-SQL Server, Oracle, Sybase Advantage and Firebird.

Looking to make some money?

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

Bids on this Project

  • rohitrichhariya2 Profile Picture

    rohitrichhariya2

    Bhopal,  India

    Hard working, reliable and dedicated. Skills: C#, SQL Server, SSIS, SSRS, Oracle, My SQL, DB2, Postgresql, GreenPlum,CA ER win, Database designing Language: English Experience: Over 5 years of IT experience

    .NET, SQL, Oracle, and Microsoft Access

  • lokeshk9936 Profile Picture

    lokeshk9936

    Dispur,  India

    NA

    C Programming

  • ajeter5 Profile Picture

    ajeter5

    Coppell,  United States

    Austin has over 3 years experience on a variety of development and IT projects in many different types of roles. He has advanced competencies in Microsoft SQL Server 2008 R2 and 2012, Excel, Access, and Data Entry. He is most experienced in working with the Microsoft SQL Server stack starting from SSIS through SSRS Reports.

    Java, Data Entry, Excel, and Testing / QA

  • weonlydo Profile Picture

    weonlydo

    Auckland,  New Zealand

    I am a freelancer domiciled in New Zealand. Don't let my time zone fool you though - I work around the clock and can adjust my schedule to work around your project. My core strengths are programming, APIs, scripts, macros, diagnostics, server administration, troubleshooting ... have I just covered all aspects of IT? I have been in the industry nearly two decades and have done all sorts of projects from front end through back end and the middleware in between. Check out my reviews and completion rate, then judge me for yourself when I complete your project. I apologize to the stones that WILL be turned to uncover the solution to your problems, none shall be spared!

    PHP, Perl, ASP, and Java

  • pablotorres Profile Picture

    pablotorres

    Ensenada,  Mexico

    I 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 a strong knowledge of server side scripting, and client side. I can scrape data from webpages, normalize and populate into a system. The products are well documented. I deliver tested final products on my own server.

    PHP, Perl, Java, and XML

  • pyostrike Profile Picture

    pyostrike

    Gelendzhik,  Russian Federation

    That's all folks.

    PHP, Perl, C Programming, and XML

  • lightweightcoder Profile Picture

    lightweightcoder

    kolkata,  India

    We are providing enterprise level solution on JAVA, JEE, Spring, Hibernate etc. We are also engaged in the design and development of data migration from one type of DB to another. We are providing a effective and smooth solution at a very affordable pricing.

    PHP, Java, JSP, and Javascript

  • expertcoder1vw Profile Picture

    expertcoder1vw

    Lilongwe,  Malawi

    I am an experienced coder with over 19 years of coding experience in Foxpro, VB6, MS-Access, C# / VB.NET , Delphi, MySQL, MS-SQL Server, Oracle, Sybase Advantage and Firebird. Specialist in Windows database application software development. I offer to develop high quality applications at reasonable prices for even the most discerning buyers. Areas of Expertise: Foxpro, VB6, MS-Access, C# / VB.NET , Delphi, MySQL, MS-SQL Server, Oracle, Sybase Advantage and Firebird.

    PHP, C Programming, XML, and Visual Basic

  • chinbochen Profile Picture

    chinbochen

    Shanghai,  China

    I'm a Java, J2EE web application developer with over 10 years experience. I'm good at javascript/jquery/, bootstrap, HTML5, JSP/Servlet, Spring, Ant, Maven. I also have exprience with Android hybrid app development. I took good care of every project I worked on, and I will continue doing that.

    Java, JSP, Javascript, and J2EE

  • axos88 Profile Picture

    axos88

    Budapest,  Hungary

    I have started doing freelance jobs in february 2013. After bidding on a project, I always spend some time with You to clarify the task and to work out which approach is most sympathetic to you. Usually I will bid with a deadline that I am sure I can fulfill, but will try to do it as sooner, if possible.

    Perl, C Programming, Java, and Javascript