There are various forms with querries in Access that need to be converted to stored procedures in SQL Server 2005.
Knowledge of SQL Server Reporting Services (SSRS) since there are reports in MS Access that must also be converted.
## Deliverables
Requires knowledge of:
Microsoft Access
MS SQL Server
Microsoft Excel
There are various forms with querries in Access that need to be converted to stored procedures in SQL Server 2005.
You will be required to test all of the stored procedures you develop with test scripts.
The tables already exist in SQL Server with data in them.
Other conversion work is documenting the process because the Access button clicks also have some sub routines within them. (Some might be easily converted to SQL Server stored procedures.). Additional documentation is required because the buttons might also have reports, emailing, etc within them.
You MUST have a reliable internet connection and be available sometime during the hours of 9:00am to 4:00pm EST. You will be required to remote into a computer at our site. We will provide the remote software for you.
The IM for communications is Microsoft.
Knowledge of SQL Server Reporting Services (SSRS) since there are reports in MS Access that must also be converted.
Knowledge of vb.Net. is a must.? If you know C# that would also be good.
This is ongoing work for a number of different customers but is part-time.? (I am saying upfront there is no guaranteed 40 hours a week.)