Copy tables between SQL databases
Since we went through and geocoded all of the Australian postcodes and suburbs we have found ourselves finding all sorts of uses for it, and have been madly going through projects and using this data. We have the data in our master code database, and in order to make use of it in a clients project we must copy the table and its data between databases. Open up a SQL query window in the destination database and run the following code:
This works so long as the SQL databases are on the same server.