Illegal characters in path - when using SQL Compare and attempting to deploy

mghadiali

Getting "Illegal characters in path" error when using SQL Compare and attempting to deploy. Very general error message and no other details provided. What am I doing wrong or what needs to be adjusted inorder to make it work?

sam.blackburn

Is there a "more details" or "send report" link next to the error message?

SQL Compare manipulates paths in quite a lot of places, but we try to handle such errors more gracefully than that.  Specifically in deployment, you might want to check the backup/snapshot creation options in case there's an invalid path in one of those.  If you're deploying to a scripts folder, any database objects with unusual characters in their names would arouse suspicion.  However, I've tried those and wasn't able to reproduce the issue.