Allow SQL Compare Users to set the default password
When using SQL Compare and deploying a database to a new server, you may experience an error that "Password validation failed. This is caused by the password not meeting Windows policy requirements because it is too short". This is due to the default password generated by SQL Compare called 'p@ssw0rd' being 8 characters long. If your company has a policy for Windows passwords to be minimum of 9 characters, the deployment will fail as the default password does not meet the policy requirements.
Would SQL Compare Users like to set their default password for SQL Compare?
Matt Brauchler commented
I'd even be happy with them to change p@ssw0rd to p@ssw0rdddd to get around length requirements for local laptops....etc.
Steven Isaacs commented
It would be really helpful to be able to set the password for users. This would allow all information needed to be contained and migrated with SQL Compare and no other additional scripts required to add/modify user information.