Search
Friday, September 21, 2018

5

Sep

2015

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 (947)
Read more

Categories: Database, MSSQL

Tags:

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

Abraham Lincoln

Copyright 2018 by Exweeto Terms Of Use Privacy Statement