SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[SA 9.0.0152 Pro BETA] - Schema Compare

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[SA 9.0.0152 Pro BETA] - Schema Compare
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 1396

Post [SA 9.0.0152 Pro BETA] - Schema Compare Reply with quote
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.
Fri Sep 30, 2016 4:29 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6500

Post Reply with quote
I have submitted a bug report for this issue and will provide an update when available.
Fri Sep 30, 2016 11:47 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6500

Post Reply with quote
Please try the latest build 9.0.157. This issue is supposed to be fixed in that build.
Wed Oct 05, 2016 12:22 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.