error in dbatools

Question

Post reply

error in dbatools

abdalah.mehdoini

Ten Centuries

Points: 1001

July 21, 2019 at 7:53 pm

#3664883

Hello everyone ,

I must proceed to make a migration of SQL Server from version 2008R2 to version SQL 2016 I try with the dbatools Start-DbaMigration procedure

 Start-DbaMigration -Source ABDALLAH-PC\SQLEXPRESS -Destination localhost -BackupRestore -SharedPath C:\backup -WithReplace

I had this error

New-Object : Exception lors de l'appel de « .ctor » avec « 1 » argument(s) : « Operation not supported on version 10.50.4000. »
Au caractère C:\Users\abdallah\Documents\WindowsPowerShell\Modules\dbatools\allcommands.ps1:9925 : 24
+         $sourceStore = New-Object  Microsoft.SqlServer.Management.XEvent.XEStore ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation : (:) [New-Object], MethodInvocationException
    + FullyQualifiedErrorId : ConstructorInvokedThrowException,Microsoft.PowerShell.Commands.NewObjectCommand

Sans titre

thanks for help

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

pietlinden SSC Guru Points: 63436 More actions · Answer 1

I'd probably send a tweet to @psdbatools and see what happens. or #psdbatools

Jeff Moden SSC Guru Points: 1003908 More actions · Answer 2

This is why I tell people to NOT rely on "OPS" (Other People's S**T)! Teach yourself how to do it using their code as an example and write your own code. Using against SQL Server without understanding how they work eventually leads to disaster. And, yeah, I know you don't know how it works or you'd have fixed it instead of posting about it.

I also agree with @pietlinden... contact the people that wrote it because other people will eventually have the same problem and it's not actually our job to support "OPS". 😀 😀 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Shawn Melton SSC-Insane Points: 24685 More actions · Answer 3

You need to exclude the Extended Events from being copied. While SQL Server 2008 R2 did support XE it was very limited and SMO itself won't work against that version. You can have it skip that by using the -Exclude parameter of the command.

$params = @{
    Source        = 'ABDALLAY-PC\SQLEXPRESS'
    Destination   = 'localhost'
    BackupRestore = $true
    SharedPath    = 'C:\backup'
    WithReplace   = $true
    Exclude       = 'ExtendedEvents'
}

Start-DbaMigration @params

This reply was modified 4 years, 9 months ago by Shawn Melton.

Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton