If you have a view in a MongoDB database that you’d prefer to be a collection, you’re in the right place.
Below is an example of converting a view to a collection in MongoDB.
Continue readingCategory: Database Tools
Copy/Clone a Database in MongoDB
In earlier versions of MongoDB, you could use the copyDB command or its helper method, db.copyDatabase() to copy a database.
MongoDB has since deprecated these. Also, starting in version 4.2, MongoDB has removed the copydb command, and therefore also the db.copyDatabase() method, which means that you can’t use them even if you wanted to if you’re using MongoDB 4.2 or later.
Fortunately, there’s another way to copy a MongoDB database.
Continue readingCopy/Clone a Collection in MongoDB
In earlier versions of MongoDB, you could use the db.collection.copyTo() method to copy a collection.
MongoDB has since deprecated that method. Also, starting in version 4.2, MongoDB has removed the eval command. Given db.collection.copyTo() wraps eval, this means that you can’t use either of them if you’re using MongoDB 4.2 or later.
Fortunately, there’s another way to copy a MongoDB collection.
Continue readingRestore a MongoDB Database using mongorestore
If you’ve backed up a database using the mongodump utility, you can restore it using the mongorestore utility.
The mongorestore utility loads data from either a binary database dump created by mongodump or the standard input into a mongod or mongos instance.
Back Up a MongoDB Database using mongodump
There are several ways to back up a database in MongoDB. One quick way to back up a database is to use the mongodump tool.
mongodump reads data from a MongoDB database and creates high fidelity BSON files which the mongorestore utitlity can use to restore a MongoDB database.
With mongodump, you can back up a collection, a database, or all databases.
Create a SQL Server Agent Job in Azure Data Studio
In this article, I show you how to create a SQL Server Agent job in the Azure Data Studio GUI.
Here, I create a test job that includes one job step and an attached schedule.
Continue readingHow to Locate SQL Server Agent Jobs in Azure Data Studio
I wrote this post, because it may not be immediately apparent how to find the SQL Server Agent jobs in Azure Data Studio once you’ve installed the SQL Server Agent Extension.
In SSMS, the SQL Server Agent can be hard to miss, but in Azure Data Studio, it can be hard to find!
Or perhaps you’re not even aware that you need the extension, and you may be searching for jobs that simply can’t be found.
Here’s how to locate the SQL Server Agent jobs in Azure Data Studio.
Continue readingView SQL Server Agent Job History with SSMS
This article shows you how to view the history of a SQL Server Agent job in the SQL Server Management Studio (SSMS) GUI.
Continue readingView SQL Server Agent Job History with Azure Data Studio
This article shows you how to view the history of a SQL Server Agent job in Azure Data Studio.
Continue readingInstall the SQL Server Agent Extension on Azure Data Studio
One of the cool things about Azure Data Studio is that you can install extensions to extend its capabilities. One of those extensions is the SQL Server Agent extension.
This extension allows you to do stuff like create jobs, view jobs, view job history, stop/start jobs, etc.
This article shows you how to install the SQL Server Agent extension on Azure Data Studio.
Continue reading