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

Li_LIn

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

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?

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

Config in Filter.scpf

<Sequence version="1">

<Include>True</Include>

<Expression />

</Sequence>

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 '****'

DanC

Hi @Li_LIn

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