When reverse engineering a database using a DDL script, the Filegroup property of entities is ignored and not automatically populated in the General tab of the Entity.
When using a DB connection instead of the DDL script file, the Filegroup dropdown still does not show the Filegroup for the table but it does provide a list of all filegroups on the reverse engineered database.
Steps to Reproduce:
1. Reverse engineer database using the following DDL script:
Create PROCEDURE [dbo].[TestProc]
@param1 int
with execute as owner
AS
BEGIN
return 1;
END
GO
CREATE TABLE [dbo].[Test](
[col1] [int] NOT NULL,
[col2] [char](2) NOT NULL
) ON [TestFileGroup] -- Filegroup clause
GO
2. After the model is created, double-click the Entity in the Physical Model Explorer.
3. In the Entity Properties dialog, click the 'General' Tab.
Actual Results:
The Filegroup Dropdown box in the Data Space frame reads '--Not Specified --' when it should display 'TestFileGroup' as defined in the DDL script.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center