BOSSe SQL Conversion

Končano Objavljeno May 4, 2006 Plačilo ob prevzemu
Končano Plačilo ob prevzemu

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

Inženiring Microsoft Access MySQL PHP Arhitektura porgramske opreme Preizkušanje programske opreme SQL

ID projekta: #3479540

Več o projektu

4 predlogov Oddaljen projekt Aktiven May 18, 2006

Dodeljeno:

vw1841240vw

See private message.

$612.5 USD v 90 dneh
(17 mnenj)
5.1

4 freelancerjev ponuja v povprečju za $1391 na tem delu

doug5516

See private message.

$1083.75 USD v 90 dneh
(1 Ocena)
0.0
ashishnagar

See private message.

$3400 USD v 90 dneh
(0 ocen)
0.0
chigullavw

See private message.

$467.5 USD v 90 dneh
(2 ocen)
0.0