JQL Query Editor is multi-threaded and allows long running queries and return multiple result sets. ![]() It supports most used MongoDB query operations and commands. It supports ArangoDB AQL, Couchbase N1QL queries and CosmosDB SQL queries.ĭatabase Master provides powerful and intuitive extended JSON query editor for No-SQL (MongoDB, DynamoDB etc.) database engines. The query editor supports SQL Intelli-Sense, code completion, table fields, SQL operators, code highlighting, text find/replace and other user-friendly features. Query Editor is multi-threaded and allows long running queries and can return multiple result sets. Using query editor, you can execute SQL commands or scripts against any database system or data source. The query editor is extended and can also execute. Net Objects, CiscoIS, IBM Notes, SharePoint, ShapeFile, XML, JSON, HTTP Rest, GraphQL, Google Analytics and Google BiqQuerydata source connections.ĭatabase Master provides powerful and intuitive extended SQL query editor for ad-hoc database queries and can execute all types of SQL query commands. It supports also ODBC, OleDB, Esri GeoDB, OData, AutoCad Plant3D, Web Services. ![]() This now makes me Joy from Inside Out as I now know Mongo basics.Database Master supports more then 60 data sources and database systems which includes SAP HANA, Azure Databricks, Snowflake, ClickHouse, Apache Kafka, MongoDB, ArangoDB, Neo4J, Couchbase, NuoDB, Oracle, MySQL, Amazon Redshift, Amazon DynamoDB, PostgreSQL, FireBird, SQLite, MS SQL Server, MS SQL Server CE, Azure SQL, Azure CosmosDB, Azure DocumentDB, MS SSAS Server, Apache Hive, IBM DB2, IBM Informix, IBM Netezza, IBM Teradata, Apache Cassandra, Redis and Ingres database systems. Mongorestore –collection Interactions –db speakplay_analytics dump/speakplay_analytics/Interactions.bson Mongorestore –db speakplay_analytics dump/speakplay_analytics/Interactions.bson If you want to restore specific collection (table) from a mongo db use –collection parameter to do so. Mongodump –db speakplay_analytics –collection Interactions In case if authentication is enabled extra parameters needs to be passed on to mongodump command, ParameterĭB in which the user is defined, mostly it would be “admin” database Mongodump.exe –db sc8prod_analytics –authenticationDatabase admin –username xxxx –password xxxx –out F:\MongoBackup\sc8prod_analytics Path of the database for which you want to create a backupģ) Specific Database behind authentication Mongodump –db speakplay_analytics –out c:/Backup/dump/speakplay_analytics The backup files will be created under \bin\dump folder This command will be backup all the databases available on the mongo instance. From the command prompt issue below commands, Backupġ) Backup all databases on the Mongo Instance ![]() Run the command prompt as administrator and navigate to Mongo/Bin folder in my case the path was C:\Databases\Mongo26\bin. I learned some commands from “ Back Up and Restore with MongoDB Tools” and would like to share. At this point of time I was Sad from Inside Out. Well reality is always bitter and I did not have those easy options. To me the task seemed simple and my initial thoughts were let’s get connected to RoboMongo or Mongo Management Studio, visit any one menu or right click on any one of the mongo database and I will find an option to backup my databases. ![]() Anger from your Inside Out and learn how to do that. Did that made you think? Why me? It should have been done by a DBA. While working on Sitecore at times one can come across a simple task for backing up and restoring mongo databases.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |