I'm in need of copying tables from DatabaseA to DatabaseB, both of which reside on the same server. This is needed to get the proir days data in to a reporting database (DatabaseB).
A restore would be easy but there are database objects exclusive to DatabaseB and they would get overwritten.
What's the best approach in my scenario? There are dozens of tables that need to be moved and I need the data to identical. I don't know the data well enough to determine what has changed and get just that data. That's why I'm thinking of copying all the tables.