When i run Export-DlmDatabaseRelease, export large size of sequences from my DB

Li_LInLi_LIn Posts: 4 New member
edited July 20, 2020 3:29AM in SQL Change Automation
How i can ignore sequences, and do not export sequences from target DB. It makes my deployment process take lots of time.

Answers

  • Hi @Li_LIn

    Would you be able to provide me with some more details on your environment setup in order to best advise on the solution here?

    - Are you using a direct SQL Change Automation project in SSMS/VS, or a SQL Source Control Project?
    - Are you using Powershell or any of the add-ons to deploy your database?


    Kind regards

    Dan Calver | Redgate Software
    Have you visited our Help Center?

  • Li_LInLi_LIn Posts: 4 New member
    I am using powershell to deploy my database

    Some codes here:
    build package: 
    - $databasePackage = New-DlmDatabasePackage $validatedScriptsFolder -PackageId $buildName -PackageVersion "1.0"

    deploy:
    - $dbRelease = New-DlmDatabaseRelease -Source $buildFolder"\"$buildName".1.0.nupkg" -Target $destination
    - Export-DlmDatabaseRelease $dbRelease -Path $path
    - Use-DlmDatabaseRelease $dbRelease -DeployTo $destination -SkipPostUpdateSchemaCheck


  • Li_LInLi_LIn Posts: 4 New member
    Config in Filter.scpf

    <Sequence version="1">
    <Include>True</Include>
    <Expression />
    </Sequence>
  • Li_LInLi_LIn Posts: 4 New member
    logs during export large sequences:

    Export-DlmDatabaseRelease, DLM Automation 2.1.3.2175, Copyright � Red Gate Software Ltd 2014-2018
    Exporting database deployment resources to folder '****'
  • Hi @Li_LIn

    Can I check, did you generate the migrations with the Filter file active in the root of the project?

    Kind regards

    Dan Calver | Redgate Software
    Have you visited our Help Center?

Sign In or Register to comment.