Longer answer: Depends on what you mean by "at the same time." If you mean "truly simultaneously" the answer is still no. If you mean "within milliseconds of each other and with the whole thing wrapped in a single transaction so that is one insert fails the other will as well" then the answer is yes.
But you can't do it with a single SQL statement. You could do it by creating a stored procedure that would insert into one and then into the other. And do it all in a single TRANSACTION.
Curiosity: Why would you do this with two separate DATABASES? I can see doing it with separate TABLES in the same database, but it would be highly unusual to do this across two DBs.
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.
The only reason I can think of for doing this would be to have one as a production database and another as the development database. But you don't have to query two databases, for that. Keep them separate and just code the pages to use one if in production, the other if in development.
If anyone knows of a website that can offer ColdFusion help that isn't controlled by neurotic, pedantic jerks* (stackoverflow.com), please PM me with a link.
* The neurotic, pedantic jerks are not the owners; just the people who are in control of the "popularity contest".
database 1) Vehicle inventory... loaded by importing.
database 2) Vehicle Global database. loaded by importing.
I load the on vehicle inventory db (1) and then I want it to goto the global database db(2) to store in our db if the vehicle comes back to us for sale again.. I can pull it out via the vin # in the global db(2)
What would be the best procedure to have them import to both databases at the same time.. and if there is a better way I would love to know.
It would be easier to drop and recreate specific tables on a weekly time frame and keep everything in the one database. That way the weekly job lists the tables to be cleared (which is easier than deleting and recreating a database) and everything else just accesses everything in the one database.