I gang

One-way database transfer

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).

So basicly:

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.

Færdigheder: Java, MySQL, Software Arkitektur, SQL

Se mere: java mssql database transfer, mysql table transfer java, select group, one group, job transfer, java batch job, a one, java database, bidding server java, sql table remove, java mysql membership, update database joomla, java mysql job, application mssql, selection group, email database work, update database mysql, mysql create database user, add exception, mysql update database, update database email, java batch application, mysql batch job, mysql remove table, check transfer files

Om arbejdsgiveren:
( 30 bedømmelser ) Bruvik, Norway

Projekt-ID: #947905

Tildelt til:

justj2ee

I am interested!

$400 USD in 15 dage
(21 bedømmelser)
4.9

19 freelancere byder i gennemsnit $383 for dette job

aoefmpes

pl check PM

$250 USD in 10 dage
(52 bedømmelser)
5.3
webcompute

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.

$500 USD in 10 dage
(6 bedømmelser)
5.2
Nzay

Please check PM

$300 USD in 3 dage
(16 bedømmelser)
4.6
gafmxq

I can do it. see PM.

$280 USD in 7 dage
(10 bedømmelser)
4.4
sisindia

Hi , If you wish i can write this in php. Thanks, DSJ

$390 USD in 4 dage
(5 bedømmelser)
3.4
wostec

Hello, Have one and half years experience in Database Administrations and Java Development. lets starts. Regards.

$250 USD in 5 dage
(1 bedømmelse)
2.4
sureshk2n

Hi plz check PMB

$750 USD in 15 dage
(1 bedømmelse)
1.2
OpenSrc

please check your pmb

$500 USD in 14 dage
(0 bedømmelser)
2.6
MohammedAlbably

I have previous experience in writing interfaces' scripts between different databases, specifically between MS SQL, Oracle and MySQL and for financial applications.

$250 USD in 10 dage
(0 bedømmelser)
0.0
satyapalgarhwal

ready to work with u

$700 USD in 10 dage
(0 bedømmelser)
1.8
dreamtech2001

PLEASE CHECK PM

$600 USD in 45 dage
(0 bedømmelser)
0.0
hutac1

please see your inbox, thanks.

$400 USD in 10 dage
(0 bedømmelser)
0.0
deepakmalik

Work 4 years as a Software Developer. Familiar with Enterprise technologies (Documentum, different Application Servers) and many programming languages. Technical Skills: Documentum ( 2 years ) DC, WebTop, Mere

$300 USD in 4 dage
(0 bedømmelser)
0.0
Sundar878

Sounds simple and great. I can do it with ease.

$300 USD in 7 dage
(0 bedømmelser)
0.0
lightweight

Please check your pm,thanks.

$250 USD in 5 dage
(1 bedømmelse)
0.0
crmexpert25

Hello. Please see PM.

$298 USD in 15 dage
(0 bedømmelser)
0.0
miofuture

commandline application or standalone java GUI for easier interaction

$300 USD in 10 dage
(0 bedømmelser)
0.0
bspopescu

Hi i am ready to start working. I have 6 years java/j2ee experience in banking software.

$250 USD in 4 dage
(0 bedømmelser)
0.0