Given an internal user database in MS SQL Server.
Create a commandline java application to transfer a selection of users from the application to a table in mysql, including removing users from the mysql table if they are removed from MSSQL. That is a one way synchronization from ms sql server table to a mysql table of users, where mssql is the master table.
The mysql data table is used by Joomla. When transfering the users you must also check and update one or two other tables with group membership information. This could also be the case for existing user (that is the group memberships may have changed).
1. Select users with group from MSSQL
2. Add user to mysql if not exists, including sending an email to the user with generated password
3. Update the users group memberships in mysql
4. Remove any users from mysql that do not exist in mssql
This application will run as a batch job regularly.
All parameters including sql statements to be externalized into properties files.
High quality work required. That is properly formatted and commented code. Proper logging and and exception handling. Please take into account when bidding.
19 freelancers are bidding on average $383 for this job
Hello I'm really interested on your project. I've good experience of JDBC on Mysql and JPA . I can make this program using java i.e compressed jar file and runnable via Batch file.
I have previous experience in writing interfaces' scripts between different databases, specifically between MS SQL, Oracle and MySQL and for financial applications.