Comments
Sort by recent activity
Seems to work with a PreScript, in SSMS. When generate script with SqlCompare, you can also verify, before you run. [image] / comments
Seems to work with a PreScript, in SSMS. When generate script with SqlCompare, you can also verify, before you run.
Did a retake, know it works. A new copy and carefully only select Custom filter rules.... And know the correct number of objects is selected. May be is was that I changed the Schema node first, and the restore failed some how?
[image]
/ comments
Did a retake, know it works.A new copy and carefully only select Custom filter rules.... And know the correct number of objects is selected. May be is was that I changed the Schema node first, and...
Hi! I have the same issue, I want to format the "and" indented with join, like when using and in a where clausule.
-- a. I get this when using "and" on a join, looks very silly inner join dbo.Jobs as j on j.Id = jr.JobId and j.ReportId = 'ROL001' -- b. I can accept this inner join dbo.Jobs as j on j.Id = jr.JobId and j.ReportId = 'ROL001' -- c. I want this inner join dbo.Jobs as j on j.Id = jr.JobId and j.ReportId = 'ROL001' In the Formating styles / Clauses / Join, the closest is to:
ON Condition / Place ON keyword on new line / Indented
result like b. /Jonas
/ comments
Hi!I have the same issue, I want to format the "and" indented with join, like when using and in a where clausule.
-- a. I get this when using "and" on a join, looks very sillyinner join dbo.Jobs a...
Yes, in removed the usage of custom file groups for text/image columns, for internal usage. Steps to clean up 'MyTable':
Drop keys for 'MyTable' (ForeignKey + PrimaryKeyUnique)
Rename table (exec sp_rename 'MyTable', 'MyTableOld'; )
Create new table on default (textimage_on [PRIMARY] )
Copy data to new table (insert into dbo.MyTable (x, y, z) select x, y, z from dbo.MyTableOld; )
Add keys to new table (PrimaryKeyUnique + ForeignKey)
Add default constraints and documentation (same as MyTableOld)
Drop old table (drop table [dbo].[MyTableOld]; )
Empty custom file (dbcc shrinkfile (MyFileName, emptyfile); )
Remove file (alter database DDM_Content remove file MyFileName; )
Remove file group (alter database DDM_Content remove filegroup MyFileGroupName; )
In repository, no file groups. At customer site use custom file groups as before. / comments
Yes, in removed the usage of custom file groups for text/image columns, for internal usage.Steps to clean up 'MyTable':
Drop keys for 'MyTable' (ForeignKey + PrimaryKeyUnique)
Rename table (exec sp...
Hi Rob! I'll have some improvement suggestions that may be of interest [image]
(Can't find a list of improvements to vote on, you should have one)
Add custom format items in Project description panel. (heading, link, list, ..) In a project description you should be able to add important links(i.e. to project homepage, ..). May be with the same functionality as in the forums.
Add support for documentation of the sys.sp_addextendedproperty When adding classification data to columns, it should be in the documentation.
Add support to collapse expander(i.e Database Properties, Database Options, Files) When generating the documentation all expander are expanded, making the page large. [image]
Add support for diagrams in Object types When adding diagrams, it should be in the documentation.
#SqlDoc #Improvement
/ comments
Hi Rob!I'll have some improvement suggestions that may be of interest
(Can't find a list of improvements to vote on, you should have one)
Add custom format items in Project description panel. (he...
Pasting RTF-format text into Project description, looks OK in SQL Doc, but doesn't work.
When generating HTML, please ensure valid HTML, use The W3C Markup Validation Service.
/ comments
Pasting RTF-format text into Project description, looks OK in SQL Doc, but doesn't work.
When generating HTML, please ensure valid HTML, use The W3C Markup Validation Service.