I can successfully compare a SQL Database with Source Control (TFS), however when I add the /Synchronize command, the differences do not get checked into Source Control.

It looks like the export starts (migration folder gets created and the differentials are printed as Verbose entries re: Command Line). Once the differentials are written to the log, the process just stops & TFS does not reflect any of the changes.

I have put what I believe to be the relevant parts of the Log run with Verbose enabled. If it makes a difference, the deployment where it is currently failing is two schema and one stored procedure (all updates to existing objects).

Oh no! We can still get our changes into TFS via SQL Source Control, so we can make it work.

Was really hoping to monitor & check into test using the command line - at least I'm still able to see the potential changes. Would be used for purposes of integrating into our mechanism for version control on a wide array of file types.

Any chance it is something being considered for a future release?

Thanks very much for your help!

Edit: I see what you're suggesting now would still give us what we need (I think) - will try to implement that. Thanks again

Hmm - /Scripts2 ought to work, as far as I know. I can only find a few people who have hit that error before, and it doesn't seem like we ever figured out what caused it - one guy reported that it went away after a reboot, and another only ran into it after he'd been using SQL Changeset, which was the ancestor of SQL Source Control, and I assume that doesn't apply to you.

Can you try rebooting, on the off-chance that that might help? Sorry I can't be more specific!

I've had a chat with the developers - this definitely should work, so we think it's a bug somewhere in our code. We're working on resolving that - I'll update you as soon as we've got somewhere, but do let me know if you can make any progress yourself. Sorry for the inconvenience!

I got the same, "Error: Deployment to scripts folders is not supported by VersionedWork.", error when trying to update a scripts folder using "Direct from source control" as my Source. If you just get latest version of this folder to pull it down locally and then switch your source to "Scripts folder" this error went away and I was able to update my Target Scripts folder no problem.