One-way database transfer

$250-750 USD

已完成

已发布

大约 13 年前

$250-750 USD

货到付款

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.

Java

MySQL

Software Architecture

SQL

项目 ID: 947905

关于此项目

18提案

远程项目

活跃13 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@justj2ee

I am interested!

$400 USD 在15天之内

4.9

(22条评论)

4.9

18威客以平均价$390 USD来参与此工作竞价

@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 在10天之内

4.8

(15条评论)

6.1

@Nzay

Please check PM

$300 USD 在3天之内

4.8

(16条评论)

4.6

@gafmxq

I can do it. see PM.

$280 USD 在7天之内

4.9

(10条评论)

4.3

@sisindia

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

$390 USD 在4天之内

5.0

(5条评论)

3.4

@wostec

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

$250 USD 在5天之内

5.0

(1条评论)

2.4

@sureshk2n

Hi plz check PMB

$750 USD 在15天之内

3.2

(1条评论)

1.2

@hutac1

please see your inbox, thanks.

$400 USD 在10天之内

0.0

(0条评论)

0.0

@miofuture

commandline application or standalone java GUI for easier interaction

$300 USD 在10天之内

0.0

(0条评论)

0.0

@crmexpert25

Hello. Please see PM.

$298 USD 在15天之内

0.0

(0条评论)

0.0

@lightweight

Please check your pm,thanks.

$250 USD 在5天之内

0.0

(1条评论)

0.0

@Sundar878

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

$300 USD 在7天之内

0.0

(0条评论)

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, EDMS98 client customization and development, strong skills in API, DFC, Docbasic , Lifecycle, Workflow Programming Languages ( 2 years ) C, C++ , PHP , Asp.Net 3.5 , C#.Net, Web Scrapping , MVC architecture (Integration of Spring 3.0(as model or dependency injuction) , JSF 2.0 with Rich faces 3.3.3(as view and controller(faces servlet)), Hibernate 3.0(annotations) or EJB 3.0 for database layer) , LDAP (Light Weight directory access protocol) , Silverlight , Google App Engine, Java, J++, JSP, Swings, Struts 2.0 , Remote Method Invocation(RMI), Web Services , EJB 3.0 , Web Services , PHP , HTML, XML , XLT, JavaScript, VB Script, Basic, SQL, PL/SQL, Pascal Payment Gateways:Paypal Technologies ( 2 years ) COM, EJB, J2EE, MFC, ATL, ODBC,ADO, JDBC, ActiveX Application servers ( 3 years ) Apache Tomcat, BEA Weblogic, IBM Websphere,JBOSS IDE ( 3 years ) Microsoft Developer Studio (C++, J++, Basic), JBuilder, JDeveloper, NetBeans, Eclipse, JDK Platforms ( 5 years ) Windows Vista,XP,7 Office Programming ( 5 years ) Word, Excel, Access Contact: gmail:deepakmalik866 skype:deepakmalik866 With Thanks and Regards, Deepak Malik

$300 USD 在4天之内

0.0

(0条评论)

0.0

@OpenSrc

please check your pmb

$500 USD 在14天之内

0.0

(0条评论)

2.6

@dreamtech2001

PLEASE CHECK PM

$600 USD 在45天之内

0.0

(0条评论)

0.0

@satyapalgarhwal

ready to work with u

$700 USD 在10天之内

0.0

(0条评论)

1.8

@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 在10天之内