Access to SQL Utility

Закрито Опубліковано %project.relative_time Оплачується при отриманні
Закрито Оплачується при отриманні

This project has two parts.

**Part 1:

**We have 12 access 2000 database files. The schema needs to be recreated in SQL Server 2000/2005 format as one large database with all indexes, relations, and tables. There are approximately a total of 50-60 tables. There are no queries to convert - only the basic table layout.

**Part 2:**

Create a utility using VB6 that will read all of the data contained in each of 12 database files and re-create the data in the newly created SQL format. This utility must have a "setup" screen where the user can specify the location of the MDB files as well as the location of the SQL server with username/password.

## Deliverables

As there are two parts to this project, there are two deliverables.

**Deliverable 1:

**SQL script that will execute on SQL Server 2005

**Deliverable 2:**

Executable and Source Code (VB6), using JET and/or ADO via code (no ado controls) to migrate existing data to newly created sql layout. Utility must have a screen that allows the user to specify location of MDB files and destination location for SQL Server data including username & password.

**RULES:**

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

Access 2000 for Original Database

SQL Server 2005 and SQL Server 2005 Express for NEW Database

All code should be written using VB6.

Jet and/or ADO must be utilized.

No database controls or third-party controls should be used for this project.

Техніка Microsoft Access MySQL PHP Архітектура ПЗ Тестування ПЗ SQL

ID Проекту: #3896648

Про проект

10 заявок(-ки) Дистанційний проект Остання активність Feb 7, 2007

10 фрілансерів(-и) готові виконати цю роботу у середньому за $220

michaeldstephens

See private message.

$318.75 USD за 30 дні(-в)
(96 відгуків(и))
5.8
khozak

See private message.

$212.5 USD за 30 дні(-в)
(15 відгуків(и))
3.9
georgemb

See private message.

$85 USD за 30 дні(-в)
(18 відгуків(и))
3.6
lashervw

See private message.

$85 USD за 30 дні(-в)
(5 відгуків(и))
3.1
dangersoftvw

See private message.

$85 USD за 30 дні(-в)
(4 відгуків(и))
1.9
dataquestco

See private message.

$505.75 USD за 30 дні(-в)
(1 відгук)
2.9
accessbill

See private message.

$425 USD за 30 дні(-в)
(0 відгуків(и))
0.0
phillydataguru

See private message.

$170 USD за 30 дні(-в)
(0 відгуків(и))
0.0
mudunuri

See private message.

$143.65 USD за 30 дні(-в)
(0 відгуків(и))
0.0
asrobson

See private message.

$170 USD за 30 дні(-в)
(0 відгуків(и))
0.0