When generating schema scripts, I have the ability to include or exclude
the storage options for a table. However, when the primary key constraint
is generated, it includes the storage clause. Is there a way that I can
disable that? If not, please consider that feature in the future.
I'm using MS Sql Server. Two tables from my schema are shown below. The
second has a primary key. I want to move these tables to another database
that doesn't have a file group named [ARP_METAData01].
MSSql Server
CREATE TABLE "dbo"."BKP_transformation_target_field" (
"transformation_target_field_id" int IDENTITY(1,1) NOT NULL,
"transformation_target_id" int NOT NULL,
"data_element_id" int NOT NULL,
"execution_order" int NULL,
"business_rule_type_id" int NOT NULL,
"business_rule" nvarchar(max) NULL,
"business_rule_owner_id" int NOT NULL
)
GO
CREATE TABLE "dbo"."Component" (
"Component_id" int IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
"Structure_id" int NULL,
"Data_Element_id" int NULL,
CONSTRAINT "PK__Componen__DA7521125EDC5785" PRIMARY KEY
CLUSTERED("Component_id")
ON [ARP_METAData01])
GO
Product: Aqua Data Studio
Version: 19.0.0
Build #: 55797
Build Date: 2018-Apr-24 08:26:49 AM
Operating Environment: Windows 10 (10.0, amd64) / Cp1252 / en / US / Oracle
Corporation 1.8.0_102-b14
Memory: Max=1,060,634,624; Total=1,060,634,624; Free=357,733,544; CPUs=8
In-Window Graphics Capabilities
Graphics Vendor: Intel
OpenGL Renderer: Intel(R) HD Graphics 630
OpenGL Version: 4.4.0 - Build 21.20.16.4664
Double-Buffering: Enabled
Anti-Aliasing: Enabled
Anti-Aliasing Sample Count: 16
Hardware Acceleration: Enabled
Color Bits: Red: 8 Green: 8 Blue: 8 Alpha: 8
Depth Bits: 16
Accumulation Buffer Bits: Red: 0 Green: 0 Blue: 0
Initialization Time: 1380 ms
Offscreen Graphics Capabilities
Graphics Vendor: Brian Paul
OpenGL Renderer: Mesa OffScreen
OpenGL Version: 2.1 Mesa 7.8.2
Double-Buffering: Disabled
Anti-Aliasing: Disabled
Anti-Aliasing Sample Count: 0
Hardware Acceleration: Disabled
Color Bits: Red: 8 Green: 8 Blue: 8 Alpha: 8
Depth Bits: 16
Accumulation Buffer Bits: Red: 16 Green: 16 Blue: 16
Initialization Time: 43 ms
Hardware PBuffer Available: No
Using PBuffer: No
Using Ram Buffer: Yes
Offscreen Rendering: Enabled
Offscreen Buffer Size: 800x600
Using the [DEFAULT] keyword would work. Another option would be to omit it
altogether yielding something like this:
CREATE TABLE [dbo].[t3] (
[c1] int NOT NULL,
[c2] varchar(25) NULL,
CONSTRAINT [p2] PRIMARY KEY CLUSTERED([c1]))
WITH (
DATA_COMPRESSION = NONE
)
GO
Since the benefit, in my opinion, of generating 'Create Table' statements
from an existing database is to rebuild the table(s) on another database, a
better option would be to allow the user to specify the file group for
storage. In that case, for both data and indexes, the user would either
check a box to exclude the storage clause or manually enter the name of the
file group to use.
So, yes, assuming this explanation makes sense, please open a feature
request.
41 KB
47 KB
For just an MS SQL Server connection, add a checkbox here in SchemaScriptGenerator that says "Include Constraint Storage" . See ScriptGeneratorDialog class. Default is checked. Internally, inside of ScriptConstraint->ScriptCREATE, check if the box is checked or not and display or not display the constraint storage variable. See here.
Issue dev tested in below build:
Aqua Data Studio 20.5.0-no-ofsc-dev-39
Build #: 57047
Issue dev tested in below build:
Aqua Data Studio 20.5.0-no-ofsc-dev-39
Build #: 57047
Hi,
we have verified the issue successfully on Windows platform using dev-build 45.
We checked the Schema Script generator functionality and Script object to window as for create and alter, though "Alter" cannot be checked here as this functionality is not yet implemented for SQL Server. Except this a basic sanity for Script options, Schem synchronisation and Query builder is also done.
executed test cases can be found here.
Thanks ,
Aparna Jha
Hi,
we have verified the issue successfully on Windows platform using dev-build 45.
We checked the Schema Script generator functionality and Script object to window as for create and alter, though "Alter" cannot be checked here as this functionality is not yet implemented for SQL Server. Except this a basic sanity for Script options, Schem synchronisation and Query builder is also done.
executed test cases can be found here.
Thanks ,
Aparna Jha
Verified the issue on Mac Platform using dev build-50.
"Script Objects to Windows As" and " Script Objects to New Windows As " for Create and Create (Full) is working as expected ,able to create with the generated scripts. where as "Alter" is not generating script as this function is not implemented for SQL Server.Scripting Create and Create (Full) displays Constraints Variables for scripted tables on MAC.
Kindly find the executed test cases here.
Verified the issue on Mac Platform using dev build-50.
"Script Objects to Windows As" and " Script Objects to New Windows As " for Create and Create (Full) is working as expected ,able to create with the generated scripts. where as "Alter" is not generating script as this function is not implemented for SQL Server.Scripting Create and Create (Full) displays Constraints Variables for scripted tables on MAC.
Kindly find the executed test cases here.
We have verified the issue on Ubuntu Platform using dev-50 build
We have checked the "Schema script generator", "script object to window as" , "script object to new window as" and "script object to file as" functionalities for Create Command. We could not check for alter as this command not supported for script object yet.
Executed test cases can be found here
Thanks,
Hitesh
We have verified the issue on Ubuntu Platform using dev-50 build
We have checked the "Schema script generator", "script object to window as" , "script object to new window as" and "script object to file as" functionalities for Create Command. We could not check for alter as this command not supported for script object yet.
Executed test cases can be found here
Thanks,
Hitesh
Assigning this to Automation team for further action on this.
Assigning this to Automation team for further action on this.
QE testing has completed. Please find the details below.
https://idera.testrail.net/index.php?/runs/view/2627&group_by=cases:section_id&group_order=asc&group_id=18404
Machine IP : 10.90.1.165
Machine Name :desktop-h2v08ul\admin
VM OS: windows 10 pro
Memory: 8GB
DB Server Name :SQL sever 2017
Build Used : Build v20.5.0-RC1
QE testing has completed. Please find the details below.
https://idera.testrail.net/index.php?/runs/view/2627&group_by=cases:section_id&group_order=asc&group_id=18404
Machine IP : 10.90.1.165
Machine Name :desktop-h2v08ul\admin
VM OS: windows 10 pro
Memory: 8GB
DB Server Name :SQL sever 2017
Build Used : Build v20.5.0-RC1
Issue #15598 |
Verified |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build 57047 |
No time estimate |
For just an MS SQL Server connection, add a checkbox here in SchemaScriptGenerator that says "Include Constraint Storage" . See ScriptGeneratorDialog class. Default is checked. Internally, inside of ScriptConstraint->ScriptCREATE, check if the box is checked or not and display or not display the constraint storage variable. See here.