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
Comments
3 comments
-
-
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.
-
Hi @nzilpelwar_mlx
Sorry, the article didn't help, I'm pleased you were able to work around it!
Add comment
Please sign in to leave a comment.