Unanswered: Moving data from one database to other
I have 2 databases, There is a lot of data in both the databases, i would like to move some data from one database to the other. I would like to accept 2 parameters from the user, i.e. emplyee id & dept, on entering the 2 i will unload all the data from the tables to the flat files. Now i need to load this data from the flat files in to the other database. If the data exists in the new database it should update the data. Any workarounds on it. Thanks in advance.
Thanks for your feedback, but i want to move only specific data from tables in one database to another tables in another database. I will be accepting the dbname, employee id and dept. id from the user, based on that i will be unloading data from all the tables in to a flat file. Now i have to check whether these data exists in the other database, if not then i will hve to load it into the tables of the other database. Please advice.