I have made a change to my database and now I need to update my project with that change. When I run the Sync Relational Model Data wizard it is making me re-select the tables and stored procedures. Is this correct or am I using the wrong wizard to update my project?

Whatever you have selected before should come pre-selected. Is "Database" selected as the Sync Source ?

Yes, "Database" is the selected Sync Source. I was wrong about the Stored Procs, almost all of them are selected. None of the Stored Procs are marked as returning a result set though. This is a project that was converted from a version 1 project, if that makes a difference.

If this is the frist DB Sync in v.5.3, please select the stored procedures you want to retrieve the resultsets, and see if the selection is persisted in subsequent DB Sync procedures.

I was able to re-select the stored procs and I think that part is ok. If I try to select any tables I get the following error when syncing to the database:

Exception message:

Exception type: InternalErrorException Internal Error Exception occured in: SD.LLBLGen.Pro.ApplicationCore.MetaData.CatalogRefresher.CopyTablesAndSequencesOfMixedSyncedSchemaToNewSchema: Schema 'HRImaging.dbo' contains tables obtained from the DB however it shouldn't

LLBLGen Pro version 5.3. Build 5.3.1 -----[Core exception]-------------------- at SD.LLBLGen.Pro.ApplicationCore.MetaData.CatalogRefresher.CopyTablesAndSequencesOfMixedSyncedSchemaToNewSchema(DBSchema oldSchema) at SD.LLBLGen.Pro.ApplicationCore.MetaData.CatalogRefresher.CopyExistingTablesAndSequencesForSchemasWithMixedSyncMode() at SD.LLBLGen.Pro.ApplicationCore.MetaData.CatalogRefresher.MigrateProjectToNewCatalog() at SD.LLBLGen.Pro.ApplicationCore.MetaData.DatabaseMetaData.RefreshMetaData(IEnumerable1 populatedCatalogs, LogNode refreshLogNode, Project containingProject, UserConfiguration preferences) at SD.LLBLGen.Pro.ApplicationCore.MetaData.MetaDataStore.RefreshMetaData(String driverID, IEnumerable1 populatedCatalogs, Project containingProject, UserConfiguration preferences) at SD.LLBLGen.Pro.ApplicationCore.MetaData.CatalogRefresher.RefreshMetaData(Project containingProject, String driverID, List`1 populatedCatalogs, UserConfiguration preferences) at SD.LLBLGen.Pro.ApplicationCore.Synchronization.SyncWithDatabaseTask.MigrateModelToNewPopulatedCatalogs() at SD.LLBLGen.Pro.ApplicationCore.Synchronization.SyncTaskBase.PerformWork(LogNode parentLogNode) at SD.LLBLGen.Pro.ApplicationCore.Synchronization.SyncTaskBase.PerformSync() at SD.LLBLGen.Pro.Gui.Classes.SyncTaskRunner.PerformDbSyncTask(SyncWithDatabaseTask task, LogNode parentNode)

please provide more info: what is the sync mode in the 'sync' tab for the catalog? It looks like it's set to 'mixed', however the converted project apparently has settings not properly set (likely due to the conversion, but we don't know yet). If you set it to 'Database', does the error resolve?

Setting it to database fixed it. Thanks.