Right! ugh.

Thanks Gail.

This worked a charm: $OutputEncoding = New-Object System.Text.UnicodeEncoding($false, $false)

Thanks Gary!

Say, that's a good link. Not sure how I never came across it..

Thanks for posting.

P

Ah, right!

See these Options in the Smo.Transfer class.

$xfr.Options.DriAll = $true

$xfr.Options.DriForeignKeys = $true

$xfr.Options.DriUniqueKeys = $true

$xfr.Options.DriChecks = $true

$xfr.Options.DriUniqueKeys = $true

$xfr.Options.ClusteredIndexes = $true

$xfr.Options.NonClusteredIndexes = $true

then, call the script method on the transfer...

Found this at https://technet.microsoft.com/en-us/library/ms162153%28v=sql.105%29.aspx

Scripting Out the Dependencies for a Database in PowerShell

This code example shows how to discover the dependencies and iterate through the list to display the results.

# Set...

The Powershell would look something like this. I haven't tested it (the -o part may need some work).

One problem with the *.SQL files-in-this-folder approach is that one may run into...

Try this in Powershell: this basic functionality is relatively simple to learn.

You'll never go back to .bat

Yep, all good: when I replace TransferData() with ScriptTransfer(), the appropriate code is spewed out.

It's the TransferData() method that's broken.

Both source and dest servers (in my implementation) show Monitor...

Version 10 of smo and smoextended are both there; same on my SQL Servers.

We've developed a couple of apps using ORM and E/F. As far as I can see, they are supposed to obviate the DBA.

And they worked -- for a while. But...

Got it:

$Code = "*_GOL_*"

Get-ADGroup -Filter {(name -like $Code)} | select -ExpandProperty name

Thanks!

John: You're right about the variable not substituting. The literal "*_GOL_*" returns the correct list.

Any ideas how to make this work?

$Code = "GOL"

This returns all the groups having "GOL" in their names:

Get-QADGroup "*$Code*"

This returns all the groups having _GOL_ in their names:

Get-QADGroup "*`_$Code`_*"

Both of these return nothing:

Get-ADGroup -Filter {Name -like...

Matt: Yes, that can be handled in my design. Although as I mentioned, I'm going to have to do some serious testing in order to determine if this is even...

You're now technical talking about *bi-temporal support*, not just temporal. As in - in order to provide the correct history in your OLTP, you will need to keep track of...