[SA 9.0.0152 Pro BETA] - Schema Compare

[SA 9.0.0152 Pro BETA] - Schema Compare

When selecting databases for comparison in Schema Compare dialog there's no indication which database is used as the source and which as the destination.

Also, the generated script suffers severely in sense of dependency, for example, the CREATE USER statements are all put at the end of it, causing every CREATE PROCEDURE statements that are meant to execute as those users created later in the script.

There are some syntax errors as well, eg. the CREATE USER statements use keyword DEFAULT_SCHEMA and not DEFAULT SCHEMA and a statement like

	Code:
	CREATE USER [etl_web_ir] WITH DEFAULT SCHEMA [dbo]

is syntactically wrong even when correcting it to

	Code:
	CREATE USER [etl_web_ir] WITH DEFAULT_SCHEMA [dbo]

because it's incomplete (needs FOR LOGIN login_name, or whatsoever).

I run into a few errors in different parts of SQL Reference, you might want to check if there are other inconsistencies in it.

I have submitted a bug report for this issue and will provide an update when available.

Please try the latest build 9.0.157. This issue is supposed to be fixed in that build.