java method/utility/program for database transfer
to all geniuses out there,
does anyone here know a java program that would transfer my MS ACCESS2000 tables to MYSQL?i already know the easy way which is by exporting,what i need is a java program that will do this.i already have done a program that will transfer a mysql database to another mysql database,the problem is i cant do it from msaccess2000 to mysql.i simply cant get the right sql statement to do it.
>select * into sample from login;
*sample is the database from mysql*
*login is the database from msaccess*
i cant figure out a way so that the tables from the login database(msaccess) will be transfered to sample database which is in mysql.
any site or example will be highly appreciated...
Another way is to create a link to the MySQl table in Access and run the query. That should work. I've done it with MS Access and SQL Server. And I think DB2.
But if you have to do it from Java there is an Eclipse plugin for copying databases that are accessable from JDBC - http://dbcopy.sourceforge.net/en/dbcopy/index.html.
I've not use it yet.
i am pretty new in java programming and i dont know how to make links from access to mysql.how did u do it?could you show me some of your codes???and by the way the link you have given me is not workin, i wil try to check it later.
nwy,i rily do apreciate the reply.thanks...
Somehow a period got on the end. Pretty easy to solve.
Links have nothing to do with Java. You do those in Access. Create a new table and do a link.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL