Hot answers tagged sql-server-tools
Reading between the lines, I guess the expectation/plan was for the SQL Server Data Tools (SSDT) project type to be extended to SSMS for the release of SQL 2012. Evidently that didn't happen, so we're stuck with the (frankly dreadful) SSMS interpretation of a project. If you want something to manage your database source, you should be diving deep into SSDT. ...
Is creating a linked server on one of those an option? If so you could probably do this using something similar to the following query (untested): INSERT INTO Server1.db1.dbo.Table1 SELECT * FROM dbo.Table2 EXCEPT SELECT * FROM Server1.db1.dbo.Table1 If not, then maybe take a look at SQL Server replication
Only top voted, non community-wiki answers of a minimum length are eligible