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.
WORKAROUND:
Restore the OREDDLMS.txg and OREDDLMS08.txg packages in TDM:
1. Close TDM
2. Go to c:\Program Files\Quest Software\Toad Data Modeler 3\Packages\System\ (in Windows XP)
3. Backup the current packages OREDDLMS.txg and OREDDLMS08.txg into a separate folder (ie: c:\temp).
3. Extract the packages attached (OREDDLMS.zip) to the original folder (c:\Program Files\Quest Software\Toad Data Modeler 3\Packages\System\)
4. Launch TDM and reverse engineer database using the same script.
STATUS:
Waiting for fix in a future release of Toad Data Modeler.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center