BOSSe SQL Conversion

Completed Posted May 4, 2006 Paid on delivery
Completed Paid on delivery

Introduction Foresight Computer Solutions sell a life and pensions administration solution to independent brokers in Ireland. This application will built using Visual Basic with a Microsoft ACCESS database. The company now need to have Microsoft SQL Server support and require all the SQL in the current application rewritten so that it can be used with SQL Server. Size SQL code currently resides in a number of areas within the application. The table below outlines the areas and the number of queries. BOSSe is the core ACCESS database with 90 tables. Each SQL statement has been reviewed and the code classified according to level of complexity. Simple queries are single table queries with our without parameters or multi table queries with no parameters and simple one-to-many relationships. Moderate queries have multi table access with parameters, order and inner join relationships. Complex queries have many different complex topics such as external relationships etc. ADO Queries simple moderate complex 303 242 47 14 28 23 3 2 12 12 0 0 9 9 0 0 222 205 10 7 44 2 7 35 24 4 6 14 35 3 5 26 SQL in code 221 221 0 0 DAO 15 NA NA NA ACCESS queries 9 0 9 0 2 0 2 0 3 0 3 0

## Deliverables

Conversion Process The Microsoft ACCESS databases and a Visual Basis Project will be delivered. The VB project files will have all ADO SQL objects. All .EXECUTE commends will have been converted to ADO by the time of delivery (circa. End of May). These files must be returned with appropriate test code, ADO objects and SQL Server Initiation commands for the databases delivered. Response Format Please respond to this bid with the following information: History of VB / SQL server projects to date Size of project Value of Project Client (or if confidential, nature of Client) Proposed contract value

## Platform

Windows 95 and above Microsoft Server on all server platforms

Engineering Microsoft Access MySQL PHP Software Architecture Software Testing SQL

Project ID: #3479540

About the project

4 proposals Remote project Active May 18, 2006

Awarded to:

vw1841240vw

See private message.

$612.5 USD in 90 days
(17 Reviews)
5.1

4 freelancers are bidding on average $1391 for this job

doug5516

See private message.

$1083.75 USD in 90 days
(1 Review)
0.0
ashishnagar

See private message.

$3400 USD in 90 days
(0 Reviews)
0.0
chigullavw

See private message.

$467.5 USD in 90 days
(2 Reviews)
0.0