How can we help you today? How can we help you today?

Invoke-DatabaseBuild cmdlet freezing

I am trying to build a database from the scripts on an empty database for a CI environment and also create a verbose log to capture any errors and fail the job if the build fails.
I'm trying to use the Invoke-DatabaseBuild cmdlet and have been testing a script from PS, but for some reason it's doing nothing. Here is my shell:
PS C:\Users\byunger> Invoke-DatabaseBuild "C:\Users\byunger\.jenkins\workspace\SQL_BUILD\Database (backend)" -SQLCompareOptions "NoTransactions" 
-TemporaryDatabaseServer 'Data Source=AWS-JENKINS' -TemporaryDatabase 'Data Source=AWS-JENKINS;Initial Catalog=TestBuild'  -Verbose

Invoke-DatabaseBuild, SQL Change Automation 4.3.21041.24117, Copyright © Red Gate Software Ltd 2014-2021
Validating SQL Source Control project 'C:\Users\byunger\.jenkins\workspace\SQL_BUILD\Database (backend)'.

It stays in this running position forever without doing anything. Any help is appreciated!
Ben
0

Comments

4 comments

Sort by
  • DanC
    Hi BenYunger

    Could you please add the following to the top of your script?

    $DebugPreference = 'Continue' 

    $VerbosePreference = 'Continue' 

    If you prefer, I can also reach out vias a support ticket to keep information confidential and secure! 

    DanC
    0
  • BenYunger
    Hi, I tried your suggestion , it helped that I can now see verbose logging in the console, but it did not resolve the overall issue. I have an ongoing support ticket 249777, please join to help me resolve this fully.
    Thank you
    BenYunger
    0
  • BenYunger
    @DanC do you have access the support ticket I have open? Do you have any suggestions?
    BenYunger
    0
  • DanC
    Hi @BenYunger

    I can see the ticket is with my colleague Pete who should be able to help you resolve that issue!
    DanC
    0

Add comment

Please sign in to leave a comment.