Additional files like .ndf (other than .mdf and .ldf) and Filegroup are ignored by Schemazen.

[Panidakii]

Hi,

Schemazen skipped.ndf and filegroup when extracting and creating database.

For example, the new database created from the Schemazen script did not create DocumentData filegroup and Mydatabase_DOC.ndf.

Here is the original database that have 3 files (Mydatabase.mdf, Mydatabase_DOC.ndf, and Mydatabase.ldf)

CREATE DATABASE [Mydatabase] CONTAINMENT = NONE ON PRIMARY ( NAME = N'Mydatabase_Data', FILENAME = N'D:\MSSQL\Data\Mydatabase.mdf' , SIZE = 5147648KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%), FILEGROUP [Document] ( NAME = N'DocumentData', FILENAME = N'D:\MSSQL\Data\Mydatabase_DOC.ndf' , SIZE = 102400KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1%) LOG ON ( NAME = N'Mydatabase_Log', FILENAME = N'D:\MSSQL\Log\Mydatabase.ldf' , SIZE = 651712KB , MAXSIZE = 2048GB , FILEGROWTH = 1%) COLLATE SQL_Latin1_General_CP1_CI_AS

Thank you,