Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [string] $mongoDriverPath = (Get-ItemProperty "HKLM:\SOFTWARE\Microsoft\.NETFramework\v3.5\AssemblyFoldersEx\MongoDB CSharpDriver 0.11").'(default)';
- [string] $AtlantisSchemaEngineBaseDir = "C:\justin's projects\Atlantis Schema Engine\";
- [string] $SqlServerInstance = '.\MyInstance';
- [string] $dbName = 'master'
- Add-Type -Path "$($mongoDriverPath)\MongoDB.Bson.dll";
- Add-Type -Path "$($mongoDriverPath)\MongoDB.Driver.dll";
- Add-Type -Path "$($AtlantisSchemaEngineBaseDir)\Atlantis.SchemaEngine\bin\Debug\Atlantis.SchemaEngine.dll"
- [MongoDB.Driver.MongoDatabase] $db = [MongoDB.Driver.MongoDatabase]::Create('mongodb://localhost/atlantisSchemaEngine');
- [string] $cnStr = "Data Source=$SqlServerInstance;Initial Catalog=$dbName;Integrated Security=SSPI;";
- $schemaReader = [Atlantis.SchemaEngine.Container.SQLServer.SQLServerSchemaReaderFactory]::GetSpecificSQLServerSchemaReader($cnStr, [Atlantis.SchemaEngine.Enumerations.ContainerMode]::Comparison)
- [Atlantis.SchemaEngine.Container.SchemaContainer] $dbObjects = $schemaReader.ReadObjects();
- foreach ($dbObject in $dbObjects) {
- try {
- Invoke-GenericMethod $db["alantisSchema.$($dbName)"] Insert Atlantis.SchemaEngine.SchemaElements.SysEntry $dbObject
- [MongoDB.Bson.BsonDocument] $doc = New-Object -TypeName MongoDB.Bson.BsonDocument;
- $doc["Name"] = "Justin";
- Invoke-GenericMethod $db["test"] Insert MongoDB.Bson.BsonDocument $doc;
- #[MongoDB.Bson.BsonExtensionMethods]::ToBsonDocument($dbObject);
- break;
- } catch [Exception] {
- $_.Exception.ToString();
- break;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement