I guess I had better check out the info on linked servers! I will post again once I get a little info under my belt. I am also thinking I...

So no "append" in SQL Server? I am more of a PostgreSQL or MySQL person and there is append in those...this seems like it should be easier. I am...

Thanks for the reply! The most current data resides on database2 but database1 has data on it that database2 does not! And I am not sure how much new data...