Can you please give me some advice in the direction I should take?
The scenario that I have is 150 different SQL databases that all have data in them. I would like to run reports and display the data in one database and in this process we are going to need to add primary key when the data is dumped into that 1 master database. All the procedures are going to be done on server side can you please suggest which direction to take ex. Stored procedures, Views or something else. The environment that we are running is SQL 2014 Standard. All the tables are the same.