SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Connect to MongoDB on Remote Linux Server with Powershell

By Michael D'Spain ,

Depending on your view point, I have the lovely task, or not so lovely task or pulling data from 700+ MongoDBs on a linux servers into a SQL Server DB to build some reporting around a specific data point.  Using Powershell and the POSH-SSH module I was able to accomplish this.  I wasnt able to find much out there for this scenario.  Most of what I found was connection to MongoDB on a Windows box.   Please read my comments in the script for the explanation of how this works.  

Hope you find this useful.  

Good times. 

Michael D'Spain 

Total article views: 173 | Views in the last 30 days: 3