schemazen
schemazen copied to clipboard
sethreno
Script and create SQL Server objects quickly
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...
Hi, I've run into an exception while having specific culture settings on my pc. This culture (Czech), together with many others, uses comma instead of dot in decimal numbers. (e.g....
Hi, When extracting and creating CCI index the structure is different and it doesn't create the table or index. Example: Source: CREATE CLUSTERED COLUMNSTORE INDEX [CCI_SCHEMAZEN_ROX] ON [dbo].[SchemaZen] Trying to...
Hi! Script from managment studio: CREATE TABLE [dbo].[Document]( ... [CreatedDate] [datetime2] (3) NOT NULL, ... Script from schemazen: CREATE TABLE [dbo].[Document]( ... [CreatedDate] [datetime2] NOT NULL ... As a result...
```sql EXEC sys.sp_addextendedproperty @name=N'MS_Description',... ``` and other extended properties
rowguid is not importing/creating correctly in sql server 2016 if you change column.cs to this: case "sysname": if (IsRowGuidCol) val.Append(@" ROWGUIDCOL"); val.Append($" {IsNullableText}"); if (includeDefaultConstraint) val.Append(DefaultText); if (Identity != null)...
Given the schema: ``` sql create table MyTable (Id int, IdPlusOne as [Id]+1 persisted not null) ``` SchemaZen outputs the computed column without the `persisted not null` specification: ``` sql...
Wildcard option for this would be cool, like All tables ``` --dataTables % ``` Tables starting with "user" ``` --dataTables user% ``` File Input --dataTables file=some_file.txt And perhaps new option...
I think an excellent addition to this tool would be to have a script to drop table(s) in the database, including the related dependencies such as triggers, foreign keys, etc....
Hello, Thanks for your work in changing mdf and ldf directory. But I have noticed error that if database name contains space (-b "my database") then it fails to create...
