How i can ignore sequences, and do not export sequences from target DB. It makes my deployment process take lots of time.
Comments
5 comments
-
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?
-
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
-
Config in Filter.scpf<Sequence version="1"><Include>True</Include><Expression /></Sequence>
-
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?
Add comment
Please sign in to leave a comment.