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

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

How i can ignore sequences, and do not export sequences from target DB. It makes my deployment process take lots of time.
Li_LIn
0

Comments

5 comments

  • DanC
    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?


    DanC
    0
  • Li_LIn
    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_LIn
    0
  • Li_LIn
    Config in Filter.scpf

    <Sequence version="1">
    <Include>True</Include>
    <Expression />
    </Sequence>
    Li_LIn
    0
  • Li_LIn
    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 '****'
    Li_LIn
    0
  • DanC
    Hi @Li_LIn

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

Add comment

Please sign in to leave a comment.