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.
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.
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.