In Progress

MSSQL to WEB - Relational DB expert required

We have a very old database that needs to be converted to the web.

CURRENT SYSTEM:

Microsoft Access ADE file connected to MSSQL 2000 Database

Runs on Terminal Server

The Database has about 54 tables

About 11 000 main records

All data can be viewed and structures can be viewed Server Management Studio Express

All forms etc can be viewed from Microsoft Access

CURRENT LIMITATIONS:

Bad user management

Bad replication

Poor backup process

No redundancy

Very bad printing support across network

No plan for connection loss - currently when user disconnects data will get corrupted or SQL does not release the session

REQUIREMENTS:

Application must be completely web based.

Convert entire system to run on newer database can be newer MSSQL but preferred is MySQL and PHP. Either way the new system must be highly scalable and futureproof.

Focus on security is of cardinal importance, the system cannot be accessed without a key file or something similar on the users computer, the developer will have to assist us with a feasable solution.

Data to forms must be delivered via AJAX - very little reloading of screens - IMPORTANT!!

Current form layouts must remain as close as possible to the current system.

User management and rights must be easy to implement and maintained from the web.

You must have a plan in place to migrate the current data easily, when the system goes live you will only have one day to migrate - IMPORTANT!!

Optimize the back office processes.

Application must be able to run from on our servers. If you design the system for apache we would like to use XAMPP running on Windows 7 as we are not linux/apache fundies. There are currently only about 35 users that work on the system and running 8 core Xeon.

PDF Printing.

DELIVERABLES:

We will supply you with a stripped down SQL file with about 20 records

We will supply you with the ADE file

----------------------------------------------------------------------------

FUTURE PROJECTS - the successful bidder must be able to do the following as well, we prefer to stick to one developer/company and no third parties.

PROJECT 2

There is a second access database that needs to be incorporated to this system, which will be awarded to the successful bidder so the system needs to incorporated easily - THIS IS A NEW GAF PROJECT

PROJECT 3

A SMS Api needs to be integrated into the current system, currently we only require a user to send a member number to the database which will return a list of beneficiaries to the users phone. We do need detailed monthly reports of each user and the amount of queries the user did.

PROJECT 4

Fully integrated document management system, currently to many documents are floating across the network, we need it centralized system with user and rights management.

PROJECT 5

Mobile application - NOT IPHONE please

----------------------------------------------------------------------------

PAYMENTS:

All payments will be done by milestones only which we can agree upon

----------------------------------------------------------------------------

IMPORTANT:

Your bid will not considered unless you quote the word the FIRE on the top of the bid to avoid automated letters, you need to understand the requirements perfectly.

Your bid must include your monthly rate for support for 5 hours and 10 hours.

This fee will only be payable via GAF.

----------------------------------------------------------------------------

This is not a very complex project but your bid will guarantee return work for a long time.

Good luck bidding

Skills: AJAX, HTML, PHP, SQL, Website Design

See more: xampp mssql, word express web design, web studio 4, web security developer, web projects need developer, web office live, web future studio, web developer rate, web developer microsoft, web developer express, web design for fee, web design fee, web design day rate, web application quote, top web developer, top 10 design web, terminal supply, successful web developer, studio web developer, studio design web, sms assist, session replication, projects list web design, phone support 24 7, office good computer

About the Employer:
( 10 reviews ) Tzaneen, South Africa

Project ID: #1250465

Awarded to:

qtsteam

FIRE, Please check PMB for details, Thanks.

$1200 USD in 30 days
(108 Reviews)
8.7

28 freelancers are bidding on average $821 for this job

krishdts

Hello ,we have gone through your project named MSSQL to WEB - Relational DB expert required and we like to convey that we have already done similar kind of projects before also. We can address any concerns that you m More

$1100 USD in 30 days
(101 Reviews)
8.6
USAGraphicPR0

********************************************.. YOUR SEARCH ENDS HERE .. ********************************************** GET IT DONE RIGHT THE FIRST TIME! Hello Sir/Ma'am, I look forward to talking to you further and g More

$1000 USD in 8 days
(131 Reviews)
8.2
varun8211

Hi We have gone through your requirements & have the perfect skills to set up your task. Kindly see PMB for details

$900 USD in 20 days
(25 Reviews)
8.1
sharkTooth

PM for more details, Quality work 100%.

$1200 USD in 25 days
(79 Reviews)
7.7
sunztech

Please see PMB.

$750 USD in 10 days
(39 Reviews)
7.4
alinawaz88

lets do it

$999 USD in 29 days
(177 Reviews)
7.4
sikandermandal

Please See PMB.

$700 USD in 20 days
(22 Reviews)
5.9
BitsLogic

Dear Sir, FIRE. We are interested in working with you. Over the years we have worked on many projects, both large and small. They have varied in complexity from simple reusable modules to enterprise-wide web-enabled a More

$750 USD in 19 days
(22 Reviews)
5.9
sriraj1233

I have strong experience in designing Efficient Websites with PHP and MySQL over four [url removed, login to view] to be very interesting project.I can convert complete existing functionality into online web based. I was ready to sta More

$400 USD in 20 days
(107 Reviews)
5.7
mitss

we are expirenced programmer team in PHP, ASP.net please kindly check your PMB thanks..

$1250 USD in 30 days
(10 Reviews)
5.5
GediminasB

I am certificated .NET programmer working with .NET since 2002 and am able to port your application into ASP.NET MVC 3 /C#: you have all infrastructures once you are going to run the application on Windows 7. [url removed, login to view] More

$700 USD in 21 days
(4 Reviews)
5.5
exoticsolutions

Fire!!! Hello Sir. Please see PMB. Thanks

$1200 USD in 20 days
(9 Reviews)
5.5
dataconsultants

FIRE....Please check PMB for details. Thank you

$1150 USD in 16 days
(47 Reviews)
4.9
DeoTech

Hi! Kindly see PM. Regards.

$750 USD in 14 days
(6 Reviews)
4.1
triadb

Hi, please check PM

$700 USD in 0 days
(11 Reviews)
3.9
valyb

Hi, I am [url removed, login to view] programmer. I can do your projct in ASP.NET using AJAX technology too. The database will be in MSSQL (MSSQL SERVER 2008). We can work together on all the projects. Good feedback and communication wi More

$500 USD in 25 days
(3 Reviews)
3.6
rajdgreat007

FIRE Hi, Check pmb for details.

$750 USD in 30 days
(9 Reviews)
3.2
proitagent

Hi there, I am a professional database developer and web consultant and am sure I can help you in this and can start right away. Sample of my work is availabe on request. Regards

$1000 USD in 3 days
(2 Reviews)
2.7
Tpojka

I am very accurate php/mysql programmer and will be glad to do that job for You.

$750 USD in 30 days
(1 Review)
1.0
bw2w

Please check You PM.

$800 USD in 20 days
(0 Reviews)
0.0