Post reply

error avec Copy-DbaDbTableData

  • June 5, 2020 at 12:26 pm

    #3760795

    Hello

    I need to use the dbatools module to copy data from server A to server B

    although the dbatolls module is installed correctly I have an error with Copy-DbaDbTableData

    Copy-DbaDbTableData: The term "Copy-DbaDbTableData" is not recognized as a cmdlet name, function, script file, or executable program. Check the spelling of the name, or if a
    path exists, verify that the path is correct and try again.
    Line Character: 11: 1
    + Copy-DbaDbTableData @params
    + ~~~~~~~~~~~~~~~~~~~~
        + CategoryInfo: ObjectNotFound: (Copy-DbaDbTableData: String) [], CommandNotFoundException
        + FullyQualifiedErrorId: CommandNotFoundException

    Sans titre

    clear 
    $params = @{
        SqlInstance         = 'DWH'
        Destination         = 'BDDREPLIS\PREPROD'
        Database            = 'TESTO'
        DestinationDatabase = 'TESTO'
        Table               = '[dbo].[TestBulk]'
        DestinationTable    = '[dbo].[TestBulk]'
        AutoCreateTable     = $true
    }
    Copy-DbaDbTableData @params

    Sans titre

  • June 5, 2020 at 1:00 pm

    #3760832

    Did you do the install via "Install-Module" or was it the offline install mode?  If offline have you unblocked the child items and imported the modules first off

     

    Import-Module dbatools

    Copy-DbaDbDataTable

Viewing 2 posts - 1 through 1 (of 1 total)

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