Friday, March 22, 2019




Copy a Table from One Database to Another on Different Clients

Author: Exweeto

I wanted to copy the contents of a table of links from one database to another. Both databases are hosted on the cloud-based hosting platform where I host all my sites; they are the backends of DNN instances. Problem is, while I can access my databases from my local machine using MS SQL Server Management Studio (SMS), and I can connect to each database concurrently, I could not find any way to use standard SQL commands to copy the content of a table in one database to an equivalent table in another; it came up with permissions problems no matter what I tried. Here is my solution; there are probably other solutions (e.g. export to CSV, import CSV), and some may be better, but this is how I did it!

Comments (0) Number of views (1129)
Read more

Categories: Database, MSSQL


“If I had eight hours to chop down a tree, I'd spend the first six of them sharpening my axe.”

Abraham Lincoln

Copyright 2019 by Exweeto Terms Of Use Privacy Statement