The client has made the following changes to the job.
Bidding period extended.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
I have 3 data sources:
1/ Excel sheet
2/ MS Works DB
3/ Access database
All 3 need mapping to a new MS SQL Relational Database. I will provide this schema as the target.
#1 & #2 are flat files where columns can be mapped to the new fields but need to split to relational table and maintain their ID link.
#3 is an existing access database that has a similar relational structure however the tables have been renamed and the columns renamed.
I will provide sample tables and fake records (demonstrating scenarios) for suitable applicants. However, I cannot provide the final data.
To meet the criteria for me to share this with you I need to hear your approach to this data migration (i.e what tools you may apply)
Due to the confidential nature of the data, I will need to be able to run the scripts or tools on my side. If a tool is used then I need to be able to access this free or cheaply to perform the runs. (eg: RedGate trial)
OLE or ODBC with coded scripts are an acceptable o...
Sign in or Register to see more