I have two databases, I'd like to make a INSERT INTO database1.table ( SELECT * FROM database2.table );
Is it possible? I'd like this rather than export manually and import later. I'd like to keep the script SQL.
You can use proxy tables for that - have a look at the Remote Data Access feature.
Basically, you have to do the following in database 1:
Then you can access that remote table under the name table2, such as
Note, however, that the performance to access remote data might be much slower compared to local access. This is particularly true if you are joining over local and remote data. Nevertheless, this is a very useful feature.