baiju Posted October 18, 2006 Share Posted October 18, 2006 hi I have different database. Both having same tables. I want to insert all datas from first database to second database. Quote Link to comment Share on other sites More sharing options...
jvrothjr Posted October 18, 2006 Share Posted October 18, 2006 one was would be to create a sql file the load the data into the other using that filesecond way could be loading the data into an array from the first DB and dumping into the second DB using that array. Quote Link to comment Share on other sites More sharing options...
fenway Posted October 19, 2006 Share Posted October 19, 2006 And a third way would be to copy it over directly, if you can manage to login to both with the same credentials and the DBs are on the same box. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.