What are the challenges you face when working across database platforms? Take the survey
Options

Redgate DLM

I keep getting this error when building to a scratch server. SQL Server 2016. I have ignore file groups true in ComparisonOptions and in Build step...

RedGate.DLMAutomation.Shared.Errors.TerminatingException: Schema validation failed: 43 batches failed. The first error is 'Invalid filegroup 'MainFG' specified.'. ---> System.Data.SqlClient.SqlException: Invalid filegroup 'MainFG' specified.

Thanks!
MarkA
Tagged:

Answers

  • Options
    Hi @MarkA

    Thanks for your post.

    It sounds like one of our engineers needs to take a look for you.
    I've created a support ticket for you and they will be in touch soon regarding your issue.
    Customer Support
    Redgate Software
  • Options
    danielsdaniels Posts: 2 New member
    I'm working on a POC for a large existing database - and got that as well. I'm going to proceed in my POC by changing the option to ignore the filegroup. Since I MAY Need to compare filegroups, i would be curious on the resolution of this. Do I need to create a separate ticket?
  • Options
    danielsdaniels Posts: 2 New member
    Got the same error even after changing the option. Should I open a ticket?
  • Options
    Hi daniels,

    Yes, if you have a license with support and upgrades please contact us at support@red-gate.com

    Thank you,
    Sergio
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
  • Options
    The original poster's issue was caused by an old migration script that hadn't been updated to version 6
    Sergio
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
Sign In or Register to comment.