Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hioncc
Starting Member
1 Post |
 Posted - 2011-02-21 : 15:58:26
|
| Hello,Thank you kindly for taking the time to read this.I have two databases:-Database A (This has all my customer data, order data, etc). With 250 odd tables.-Database B (This has all the tables, but is blank with no data).The databases are almost exact, a few new tables in Database B. They are both on localhost.Now, how is the best way to move all the data from Database A, into the exact same tables that are blank on Database B?I mainly script HTML/PHP, and as such have little knowledge of MySql.I am hoping someone can assist as it would be greatly appreciated.Kindest Regards |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-02-21 : 16:08:40
|
| This forum is specifically for Microsoft SQL, so while many people here have a great deal of in-depth knowledge of MS-SQL, they may not be able to offer much for MySQL. If you are using MS-SQL, probably the simplest way is to use the DTS wizard which you can invoke by right clicking on the target databases in object explorer in SSMS and selecting Tasks -> Import Data. Then follow the instructions in the wizard. |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-02-22 : 01:39:32
|
Just an idea:Use phpMyadmin to export the data from the source tables in form of insert statements.Then you can run that statements again the destination database.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
Inserting Data from One Database to Another