Hi, I have 3 databases with different names and in 3 databases the tables are same but in tables the orders are different. i want to merge this 3 databases into single database. please help me out.
if all you want to do is move all the records together into one of the databases, then you just need to insert all the records from database 2,3 into database 1 into that table. however you need to know what your doing. make sure those tables dont have relations with other tables. these questions are difficult to answer without having the entire picture in front of you. please give more details.
if I were you i would create another database with same database structure but without the data. Then load that database from existing databases 1, 2 and 3. Then test if everything is working. If it works then just use the new database or empty and then import to the database which you want to use.