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

Bug report: Sync-DlmDatabaseSchema seems to ignore some items in -FilterPath .scpf file

Our filter file has a filter to exclude some tables like this:

      <Table version="1">
        <Include>False</Include>
        <Expression>(name = 'Table1') OR (name = 'Table2') OR (name = 'Table3')</Expression>
      </Table>

One of these tables had FileStream enabled for some blob data in the destination databases.
This was not the case for the source database.

The console output contains this text (3 times the same) :
Applying update to database 'db_name' Completed: 100% Progress completed9 of 439

(Medium) Table [dbo].[Table2] contains filestream data in column COLUMN_X. The table must be rebuilt. The data in the table apart from dropped columns will be preserved.
(Medium) Table [dbo].[Table2] contains filestream data in column COLUMN_X. The table must be rebuilt. The data in the table apart from dropped columns will be preserved.
(Medium) Table [dbo].[Table2] contains filestream data in column COLUMN_X. The table must be rebuilt. The data in the table apart from dropped columns will be preserved.

The data was not lost but was converted to normal blob data, and the FileStream property was removed from the column.

Our command line was like this:
Sync-DlmDatabaseSchema -Target New-DlmDatabaseConnection -ServerInstance "SqlServerName" -Database "SqlDatabaseName" -Source "structPackage.nupkg" -FilterPath "FilterRulesRedGate.scpf" -SQLCompareOptions "IgnoreFullTextIndexing,  UseClrUdtToStringForClrMigration, IgnoreCollations, IgnoreUsersPermissionsAndRoleMemberships, -ForceColumnOrder" -AbortOnWarningLevel None


LouisSomers
0

Comments

3 comments

Sort by
  • Eddie D
    Hi,
    Thank you for your forum post.

    Have you by any chance deployed an object or objects that references or has a dependency on the filtered object?

    If yes, objects excluded by the filter are  included in the deployment as dependencies. If an excluded object is referenced by an object you selected for deployment.

    Many Thanks
    Eddie
    Eddie D
    0
  • LouisSomers
    Hi Eddie,

    Thank you for your reply.

    Does this mean that we have to exclude all stored procedures and functions that use the table?
    Also all procedures and functions that use those procedures and functions recursively?

    I don't think this would be a viable solution.
    In my opinion there should be an option to have the .scpf file overrule dependencies (enabled by default).
    LouisSomers
    0
  • Sergio R
    Hi Louis,

    You can overrule dependencies by disabling the IncludeDependencies SQL Compare option.
    You just need to add "-IncludeDependencies" as a SQL Compare option on the cmdlet.
    Sergio R
    0

Add comment

Please sign in to leave a comment.