schemazen
schemazen copied to clipboard
sethreno
Script and create SQL Server objects quickly
Foreign Keys that have been created with no name, show up as different in the Compare.
This might be some kind of "security" issue. In the tables\Events.sql : [bigpicture] [nvarchar](50) NULL CONSTRAINT [[dbo].[Events]bigpictureDefault] DEFAULT (NULL), [story] [nvarchar](255) NULL CONSTRAINT [[dbo].[Events]storyDefault] DEFAULT (NULL), on my machine it...
I have tables schema "Hangfire". Example, "HangFire.Job". I'm unable to filter these tables using the --dataTablesPattern option. Here is what i've tried, --dataTablesExcludePattern="(Job)" This works to filter out Job table....
Added 3 new options: 1. `timeout={secs}` - specify the commandTimeout for queries, as this could exceed the default 30 secs on slow machines or large databases. 2. `--noprefixdbo` - not...
Error description ------------------ I try to script an export of a database as seen below. However this fails for unknown reasons: ``` PS C:\apps> .\SchemaZen.exe script --verbose --server=SERVER --database=MES20 --user=USER--pass=PW...
Hey all, Thanks for creating this handy tool to script and compare databases. I just started using it and ran into a problem while comparing databases. The v1.4 current version...
When running on my database I get the error message: Unable to cast object of type 'System.DBNull' to type 'System.String' I downloaded the source and found that it was the...
Hello, the SchemaZen application is so good. Thank you. I have a problem. When I try to use the dataTablesPattern parameter, it does not work for me. Maybe it's because...
Hi, I scripted a large database (3000 tables and 6000 stored procedures). As the tool seemed to never ending, I pressed enter after some hours, and finally the completion message...
