Completado

Convert Access Database queries to SQL stored procedures

Hi,

I have an MDB file with tables and queries. I've already converted the tables to SQL 2005 tables. Now what I want is to convert the queries to SQL stored procedures (NOT views).

I have:

21 update queries,

13 delte queries,

88 select queries.

Most of the queries contain parameters. Which should be switched to declare input parameters in SQL 2005. (no output parameters are needed).

Most of the select queries are simple basic queries. few contain joins. All queries should be tested to work in SQL 2005. This is very important.

The selected bidder should tell me if a file of the Sql with the tables is needed or there is no need for this file to create the stored procedures (i can provide MDF file).

No optimization should be made. Only convert to Stored Procedures and test that they work when inputting some info.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

MS Access 2003, SQL Server 2005

Habilidades: Microsoft Access, MySQL, SQL

Ver más: what is package in sql, what is mdb file, what is an mdb file, what is a mdb file, i need an access database, hire microsoft access, access database software, what is ms sql, what is ms access, sql microsoft access, ms access sql, microsoft access test, microsoft access sql, test sql server, stored, stored procedures, sql views, sql microsoft, queries, Procedures, database queries, database optimization, database microsoft sql, convert ms access to sql server, access to sql

Información del empleador:
( 37 comentarios ) Netanya, Israel

Nº del proyecto: #3591905

Adjudicado a:

baburam

See private message.

$34 USD en 6 días
(74 comentarios)
5.0

38 freelancers están ofertando el promedio de $64 para este trabajo

IDenis81

See private message.

$63.75 USD en 6 días
(115 comentarios)
7.4
pShankar2

See private message.

$85 USD en 6 días
(403 comentarios)
7.1
shuvrapintu

See private message.

$51 USD en 6 días
(127 comentarios)
6.6
sharckuletz

See private message.

$85 USD en 6 días
(103 comentarios)
6.5
brightsolnslx

See private message.

$42.5 USD en 6 días
(294 comentarios)
6.4
xtremeideaz

See private message.

$85 USD en 6 días
(151 comentarios)
6.0
siberiangirl

See private message.

$85 USD en 6 días
(123 comentarios)
5.9
jawadh

See private message.

$85 USD en 6 días
(78 comentarios)
5.9
suryavijayvw

See private message.

$84.15 USD en 6 días
(109 comentarios)
5.5
omersodai

See private message.

$85 USD en 6 días
(106 comentarios)
5.3
vw736219vw

See private message.

$55.25 USD en 6 días
(52 comentarios)
5.0
perfectdone

See private message.

$34 USD en 6 días
(62 comentarios)
4.7
hassannasirvw

See private message.

$21.25 USD en 6 días
(20 comentarios)
4.5
yubor

See private message.

$63.75 USD en 6 días
(32 comentarios)
4.4
hatimtaj

See private message.

$63.75 USD en 6 días
(14 comentarios)
4.2
bucktracker

See private message.

$76.5 USD en 6 días
(25 comentarios)
4.2
nextsoftware

See private message.

$42.5 USD en 6 días
(29 comentarios)
4.1
MMMAbdou

See private message.

$85 USD en 6 días
(13 comentarios)
4.0
syedtariqvw

See private message.

$49.3 USD en 6 días
(16 comentarios)
4.0
netwizind

See private message.

$42.5 USD en 6 días
(18 comentarios)
3.9