BOSSe SQL Conversion

Completado Publicado May 4, 2006 Pagado a la entrega
Completado Pagado a la entrega

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

Ingeniería Microsoft Access MySQL PHP Arquitectura de software Verificación de software SQL

Nº del proyecto: #3479540

Sobre el proyecto

4 propuestas Proyecto remoto Activo May 18, 2006

Adjudicado a:

vw1841240vw

See private message.

$612.5 USD en 90 días
(17 comentarios)
5.1

4 freelancers están ofertando un promedio de $1391 por este trabajo

doug5516

See private message.

$1083.75 USD en 90 días
(1 comentario)
0.0
ashishnagar

See private message.

$3400 USD en 90 días
(0 comentarios)
0.0
chigullavw

See private message.

$467.5 USD en 90 días
(2 comentarios)
0.0