Migration from Access Backend to SQL Backend + Fixing VBA Errors and Adding New Featu
- or -
Post a project like this$210
- Posted:
- Proposals: 8
- Remote
- #1285556
- Expired
✪Software Developer ✪Web Developer (Java,Python, Android, jee, JSP, JSF, Java Fx,Vue, Blue J, Nuxt) ✪ Processing ✪ Elastic Search ✪ Database
Saitama
I am IT developer with 14+yrs of experience in database design and development. Expert in Migration of MS Access,SQL, VBA scripts.Excel scripts, macro thro VBA. Handled giga bytes, performance, stress
Chennai
125553261482761939896861244165135928613614101378053
Description
Experience Level: Expert
Customization of existing program
Our client has working Access Database with a lot of VBA codes and all are working with an Access Backend.
We have so far created all the tables, structures etc in SQL Backend and we just need to migrate the current data from Access to SQL Backend.
We want to migrate from Access Backend to SQL Backend. We have already created all the tables and fields in SQL Backend but we just need to migrate the data from Access Backend to SQL Backend.
We want to do this in Three Stages:
Stage 1- Migrate dummy data from Access to SQL Backend.
Once migrated, then test and ensure that all data are coming correct and IDs have not changed etc.
Stage 2-
Once data has been migrated and tested on SQL, then migrate actual data from access backend to SQL Backend.
Once actual data migrated, then test to ensure all data are migrated for each and every table and that IDs remain unchanged.
Stage 3
After migration, UK Software Ltd will test the application and make notes of any errors that will appear after the Migration. Once list of errors noted, then the Developer (you) will fix those errors. We do not expect many errors as it has been previously tested with dummy sql backend.
Please also note that you will be required to create some new queries and reports and add some new functions on the forms.
Who should apply:
1. An expert and experienced VBA developer with good knowledge of working with SQL and with previous experience in migrating from Access to SQL and trouble shooting
2. Excellent knowledge of VBA and working
3. Available according to UK time
4. Willing to work via teamviewer and to fix any errors that might come following the migration
5. Add some small 4 to 5 new functions and then fully test the database after migration
Please note that one of our Project Managers will be available to guide you through the process and help you understand that Database.
Specific technologies required: vba, access, sql
Our client has working Access Database with a lot of VBA codes and all are working with an Access Backend.
We have so far created all the tables, structures etc in SQL Backend and we just need to migrate the current data from Access to SQL Backend.
We want to migrate from Access Backend to SQL Backend. We have already created all the tables and fields in SQL Backend but we just need to migrate the data from Access Backend to SQL Backend.
We want to do this in Three Stages:
Stage 1- Migrate dummy data from Access to SQL Backend.
Once migrated, then test and ensure that all data are coming correct and IDs have not changed etc.
Stage 2-
Once data has been migrated and tested on SQL, then migrate actual data from access backend to SQL Backend.
Once actual data migrated, then test to ensure all data are migrated for each and every table and that IDs remain unchanged.
Stage 3
After migration, UK Software Ltd will test the application and make notes of any errors that will appear after the Migration. Once list of errors noted, then the Developer (you) will fix those errors. We do not expect many errors as it has been previously tested with dummy sql backend.
Please also note that you will be required to create some new queries and reports and add some new functions on the forms.
Who should apply:
1. An expert and experienced VBA developer with good knowledge of working with SQL and with previous experience in migrating from Access to SQL and trouble shooting
2. Excellent knowledge of VBA and working
3. Available according to UK time
4. Willing to work via teamviewer and to fix any errors that might come following the migration
5. Add some small 4 to 5 new functions and then fully test the database after migration
Please note that one of our Project Managers will be available to guide you through the process and help you understand that Database.
Specific technologies required: vba, access, sql
Emi H.
80% (6)Projects Completed
5
Freelancers worked with
4
Projects awarded
20%
Last project
30 Apr 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
As certified database developer i can do this job. However, I would like to know The deadline for doing this job ? do you need stored procedures to be migrated as well?
-
Emi
Access database size?
Access is offline but sql is online?
Can you share some shots or same of the access?
Regards
165223147255
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies