Search
Tuesday, December 11, 2018

21

Jul

2017

TurboDNN

Author: ExWeeto

TurboDNN is part of a set of SQL scripts for improving the performance and stability of websites running on DNN Platform.

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

Categories: CMS, DNN, Database, MSSQL

Tags:

21

Mar

2016

DNN SQL Database Housekeeping

Checking table sizes and truncating log files

Author: ExWeeto

Here are some key methods for keeping your DNN database (MS SQL Server) tidy.

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

Categories: CMS, DNN, Database, MSSQL

Tags:

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 (1044)
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