Suoritettu

MS Access conversion to MS SQL 2005

I have 4 MS Access 2002 databases with a total of approximately 120 tables. I require this converted to a single MS SQL 2005 database.

This data comes from a live system that is being updated. I plan on testing the converted data and then I will need to get any additional data over from the live system. In addition to the conversion of the data you need to supply an MS Access frontend that will have links to the newly created MS SQL 2005 database tables and also links to the existing MS Access databases/tables. This frontend will need to have a form with required code to delete all data from the MS SQL 2005 tables and then copy the data from the MS Access database/tables to the MS SQL 2005 database/tables. In form that this will be initiated from should have an input field with browse so that we can browse to the directory containing the MS Access databases and click a button to update the links. The link to the MS SQL 2005 tables should be ODBC and the data source should be named 'ONCALL'. This will enable us to set the same ODBC source on our local system so that the migration frontend will work in our environment with minimal customisation.

## Deliverables

1.) Complete MS SQL 2005 database backup or SQL to generate the new database and tables.

2.) MS Access 2002 frontend as per above details.

3.) Installation instructions

4.) Instructions on data migration frontend

5.) 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 SQL 2005

MS Access 2002

Taidot: tekniikka, Microsoft Access, MySQL, PHP, tietojärjestelmäarkkitehtuuri, Ohjelmistojen testaus, SQL

Näytä lisää: sql data conversion, ms new hire, ms access work, ms access with php, i need to hire sql, i need to hire an engineering, data conversion sql, ms access sql, sql odbc, oncall, MS SQL, MS Access Database, data source sql, access delete, sql created, access conversion, link sql, update code sql, update form access, odbc code

Tietoa työnantajasta:
( 91 arvostelua ) BONDI JUNCTION, Australia

Projektin tunnus: #3476708

Myönnetty käyttäjälle:

stevef199

See private message.

$21.25 USD 2 päivässä
(19 Arvostelua)
3.8

5 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

gargi123

See private message.

$42.5 USD 2 päivässä
(13 arvostelua)
4.0
infotechknight

See private message.

$42.5 USD 2 päivässä
(1 arvostelu)
1.3
lera25vw

See private message.

$42.5 USD 2 päivässä
(10 arvostelua)
1.0
thoughtinreality

See private message.

$51 USD 2 päivässä
(0 arvostelua)
2.0