× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Nilesh Mali
nileshhmali reported 2013-10-24T07:01:24Z  · nhilam last modified 2018-03-08T01:24:14Z

In consistent behaviour for comparison of tables.


PM
Dev
QA
Priority Low
Complexity Unknown
Component Tools - Compare
Version Future
Database version:Ms_sql server 2005
ADS version : ads-windows-x64-14.0.3
 
Connect Ms_sql server 2005
Create two table in different schema
CREATE TABLE "Admin"."Test_schema_compare"  ( 
"col1" bigint NULL,
"col2" varchar(25) NULL,
"col3" varchar(25) NULL 
)
GO
 
CREATE TABLE "dbo"."Test_schema_compare"  ( 
"col1" bigint NULL,
"col2" varchar(25) NULL,
"col3" varchar(25) NULL 
)
GO
 
Go to tools menu bar ->Select compare tools->select schema compare->select schema from schema drop down list->check tables from object
->check table from object.->click on compare.
Now go to compare window->click on table.
 
Now you will observe that double quote is missing in generated compare script.
 
 
Go to right click on table ->tools->ER modeler generator->check tables from object type->
Check table "Admin"."Test_schema_compare" from object.->click on next button.->Open entity relationship diagram.
 
Now this window->select tools from menu bar->Compare database->check table from object type-> check "dbo"."Test_schema_compare" from object
->click on next button.->open compare window->click on table.
 
Now you will observe that Datatype and sql keywords not highlighted.

 

4 attachments
  • options.jpg
    options.jpg

    2013-10-24T07:01:25Z

    125 KB

  • 1.jpg
    1.jpg

    2013-10-24T07:01:25Z

    356 KB

  • 2.jpg
    2.jpg

    2013-10-24T08:34:11Z

    206 KB

  • 3.jpg
    3.jpg

    2013-10-24T08:34:11Z

    236 KB

  •  
  •  
  • No shares
  •  
All Comments (2) Change History
Sort 

Issue #10574
New
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017