Inserting data between databases
Hello, we're using SQLPro for MSSQL. Is there a way of inserting data between different databases?
Something like this
INSERT INTO dbo.TargetTable(field1, field2, field3) SELECT field1, field2, field3 FROM SourceDatabase.dbo.SourceTable WHERE (some condition)
Hi. The above you posted should work - this is part of MSSQL in general rather than anything to do with SQLPro. See https://stackoverflow.com/questions/3502269/how-to-insert-table-values-from-one-database-to-another-database