mappings.Options = new EngineDataCompareOptions(
ComparisonOptions.TrimTrailingSpaces | ComparisonOptions.Default,
ComparisonSession session=new ComparisonSession();
SqlProvider provider=new SqlProvider();
I have discussed your case with a member of the development team. Apparently, you are using a method in the API that was designed for the UI to display a single object deployment script. It was never designed to deploy that table and as such it does not pay any attention whatsoever to the DropConstraintsAndIndexes option. She gave the following alternative to get the results that you are looking for. I haven't tried it myself, but hopefully it will work for you (she knows what she is talking about)
"The correct way to do the thing they are trying to do is probably to unmap everything but the table they want to generate the script for, generate the whole script for the database with only that table mapped, then change the mappings and generate another whole-database script for the next table like that."
Users browsing this forum: No registered users and 0 guests