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 […]
Last updated: March 12, 2012

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.

Duncan Isaksen-Loxton

Educated as a web developer, with over 20 years of internet based work and experience, Duncan is a Google Workspace Certified Collaboration Engineer and a WordPress expert.

Leave a Comment

Login
Log in below to access your courses.
Log In With Google
Forgot Password
Enter your email address or username and we’ll send you instructions to reset your password.