How to resolve partition schema error when getting source control changes?

nzilpelwar_mlx

When I try to pull latest changes from source control, it throws an error saying the partition scheme was not found, even though I created the partition function and partition scheme with the expected name and they are visible when I query for them. I don't know what is missing or how to resolve this error. 

The partition scheme [PS_SystemID] on table Audit was not found

   at RedGate.SQLCompare.Engine.Registration.ReadFromSnapshot.TableFromSnapshot.SetPartitionSchemeFromName(Database database, Table table, String partitionSchemeName)

   at RedGate.SQLCompare.Engine.ReadFromFolder.DatabaseModelPostProcessor.ProcessPartitionSchemesOnTables()

   at RedGate.SQLCompare.Engine.ReadFromFolder.DatabaseModelPostProcessor.FinalizeDatabase()

   at RedGate.SQLCompare.Engine.ReadFromFolder.DatabaseFromParseResultPopulator.Freeze()

   at RedGate.SQLCompare.Engine.ReadFromFolder.DatabaseFromScriptFilesPopulator.Freeze()

   at RedGate.SQLCompare.Engine.Model.DatabaseObjects.DatabaseFromFolderPopulator.DatabaseFromFolderPopulator.PopulateFromFolder(Database database, DirectoryInfo path, ScriptDatabaseInformation dbinfo, Options options, IEnumerable`1 filesToUse, IReadFromFolderCache cache, CancellationToken cancellationToken)

   at RedGate.SQLCompare.Engine.Model.DatabaseObjects.DatabaseFromFolderPopulator.DatabaseFromFolderPopulator.Populate(String path, CancellationToken cancellationToken)

   at 

DanC

Hi @nzilpelwar_mlx

This issues it quite notorious, and we have a help article here

nzilpelwar_mlx

Thank you for this article. The steps did not resolve the issue. I had to use SqlCompare to deploy updates using it's generated scripts. 

DanC

Hi @nzilpelwar_mlx

Sorry, the article didn't help, I'm pleased you were able to work around it!