Activity overview
Latest activity by JonasG
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.
Migrating tables with sp_rename
Need some guide how to think when migrating tables with new pk-column, to next time
Background, in my database there is two tables that need a pk migrate to identity int as pk.My try was to do it ...
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...
Script out objects for a specific schema
Hi!I'm using SQL Compare(.scp) file, to compare our repository to a release database. We add/update reports in different schemas, and I want to script out a deploy-script only for a list of schemas...
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...
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.
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...
Process log to file
Hi!I have an improvement suggestion, may be out of scope for the SQL Scripts manager, but for some scripts it may be useful.
Possible to get Process log to file.
With a corresponding .rgtool templ...
Using custom filegroups
We run a database CI project in Jenkins, with DLM Autmation plugin. One database has custom filegroups, and can't be created. The databases is stored in Subversion.
What to do?Use a pre-create scri...