No announcement yet.

INSERT INTO SELECT across connections

  • Filter
  • Time
  • Show
Clear All
new posts

  • INSERT INTO SELECT across connections

    In Microsoft SQL Server Management Studio it is possible to use an INSERT INTO server.database.schema.table SELECT * FROM server.database.schema.table statement to copy data from a table on one server/database to a table on a different server/database.

    Navicat (OSX) allows you to achieve the same result using the Data Transfer feature but is there a way to script this in a .SQL query file?

    I've successfully referred to the database.schema.table portion of the reference but I'm not sure how to include a reference to the server (connection).

    Kind regards

  • #2
    We are sorry that Navicat does not support your mentioned feature. Your request has been forwarded to our development team. We will keep improving our Navicat in the future. Thank you for your advice.