SQL Server/MSDE Expert required for upsizing project.
$200-300 USD
Lezárt
Kiadva ekkor: több mint 18 évvel ezelőtt
$200-300 USD
Teljesítéskor fizetve
Hi,
We have a Visual Basic/Access 2000 application which we are currently converting to MSDE. We need a developer to upsize the database and convert 60-70 queries from Access 2000 to MSDE SQL.
The database has 17 tables with 8 Relationships including one to many and many to many relationships.
65 Queries made up of (approx numbers):
3 Append Queries
6 Deletes
11 Update queries
2 Database schema change queries
And the rest are select queries
Some of the Select queries select from other queries so there maybe the possibility of nesting them if thats doable in MSDE.
We will only be able to provide the Access Database with sample data (Not the VB program). You will then need to upsize the database to MSDE using DTS or the upsizing wizard. Recreate all the relationships and Primary/Foreign keys to create your own Dev. environment and then re-write the queries.
The final deliverables will be:
1) An SQL backup file of all the tables and stored procedures which we can load onto our server.
2) A Word document documenting any changes to structure made during the upsizing process e.g. changing Autonumber to IDENTITY. What Indexes added, what column types changed.
We are looking for an expert developer in MSDE/SQL Server databases, and someone who has the time to finish the job. Preferably a consultant who is on some time off between contracts and fancies doing a bit of work from home.
It would be beneficial if you were based somewhere in the south west Bristol/Swindon/Chippenham area although we are mainly looking for experience over location.
Please provide a project quote and an estimate of the timescale.
Thank you