We help IT Professionals succeed at work.

Zapier api - two ms sql server

How to copy data from source to the destination server and assume both has the same structure
Comment
Watch Question

Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2019

Commented:
If you want to copy data from a single table across two databases, then the simpler way is to use Import/Export wizard
https://www.sqlshack.com/importexport-data-sql-server-using-sql-server-import-export-wizard/

Author

Commented:
I can’t the sql version is different
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2019
Commented:
FYI, Import Export Wizard works across any SQL Server versions and hence try this one and let me know whether it works..