Am new to SQL, kindly assist me with my query.
I have two MS SQL servers(version 2014) with an application data available on it, placed in 2 separate geo's, and i want to merge these two geo tables into one table, to a new MS SQL server(version 2016). both DB's hold same kind application data.
Does MS SQL support merging of two MS SQL instance into one table?
You best scenario is to use SSIS to link the two source servers with the third as destination. This would give you reusability, if you need to continue moving data from the two sources.
If it's a one-time thing, you could either