I have 2 databases, one for the West Coast and one for the East. They are exactly identical in Table Structure and names. There are about 30 tables.
The problem I am facing is that we need to bring all the data into ONE database. I've found the Import functionality helpful, but i am unsure how to Append the data together. It will import it into one database, but creates separate tables (ie. Strategy and Strategy1)
Does anyone have any guidance concerning this? Thanks!!!
The problem I am facing is that we need to bring all the data into ONE database. I've found the Import functionality helpful, but i am unsure how to Append the data together. It will import it into one database, but creates separate tables (ie. Strategy and Strategy1)
Does anyone have any guidance concerning this? Thanks!!!