Once you create the empty database I also recommend you do this to manage the ingestion since as Kristen indicated there could be duplication of identity column values
- when creating all of the tables in the new database I recommend the following
create table employeesStaging(employeeid IDENTITY(1,1) NOT NULL, **Emp_ID** int not null, sourceserver varchar(50), ...So you first stage things in employeesStaging. When ingesting the employees data from both server01Quattro, server02Quanttro you preserve the Emp_ID values that you can use as reference to the respective sourceserver. The sourceserver is there for breadcrumb purposes and in case there are, which I assume there will be, idential Emp_ID across both servers.
Also you will have to make sure you do not create duplicate employees. There should be something that uniquely identifies them such as socsec# or some other unique value that should not be across servers.
So you do the same thing for other tables by staging them first and populate it you final tables