Activity overview
Latest activity by hinsona
I'm with wstyp, bulk formatting needs Qualify Object Names. It not being there makes using SQL compare between a database that had object names qualified and one that didn't very difficult. SQL compare sees every change made by Qualify Object Names as a difference and there's no bulk way to normalize these changes across databases. I had hoped that saving a scripts folder, bulk formatting that, then comparing the two scripts folders would be the solution but found that this doesn't work because Qualify Object Names isn't used. The only option I'm aware of is tedious. Open the SQL files in SSMS, then Bulk Actions > Format All Tabs. I have too many files to open all of them at once, so I'd have to open some, process them, then move files into a processed folder. Rinse and repeat. Edit: Bulk Actions > Format All Tabs doesn't work either since it uses the same bulk formatting that omits Qualify Object Names. I had to use SQL Prompt > Format SQL, on, every, single, bloody tab. Seriously!? Is there no other way to solve this problem? / comments
I'm with wstyp, bulk formatting needs Qualify Object Names.It not being there makes using SQL compare between a database that had object names qualified and one that didn't very difficult. SQL comp...
Sergio R said:
I think that "DROP and CREATE" option can help you achieve that: https://documentation.red-gate.com/sc/setting-up-the-comparison/setting-project-options#Settingprojectoptions-AddDROPandCREATEforrerunnablescripts
I am aware of this, and the use of it results in the unnecessary dropping of all procedures affected by the script. It also means that permissions must be applied again for everything as well. It's not ideal to do unnecessary work in my opinion. / comments
Sergio R said:
I think that "DROP and CREATE" option can help you achieve that: https://documentation.red-gate.com/sc/setting-up-the-comparison/setting-project-options#Settingprojectoptions-A...
Compare script output, feature for if not exists checks.
I generate one update script from a baseline server, then use the same script against multiple server targets. The issue I've encountered, is that if one server is in a slightly different state, ev...
Tianjiao_Li said:
Unfortunately what you are asking is not possible and it can't be achieved using filter either as filters only apply at the object/table level. Can you please leave it on our user voice forum? https://redgate.uservoice.com/forums/141379-sql-compare
Thanks for letting me know. There's already a request for this very feature in the top 20, though it's 7 years old. I'm guessing me voting on it is going to make zero difference in that feature's priority. Oh well. https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/3463480-ignore-default-x-column-constraints / comments
Tianjiao_Li said:
Unfortunately what you are asking is not possible and it can't be achieved using filter either as filters only apply at the object/table level.Can you please leave it on our...
Tianjiao_Li said:
Unfortunately what you are asking is not possible and it can't be achieved using filter either as filters only apply at the object/table level. Can you please leave it on our user voice forum? https://redgate.uservoice.com/forums/141379-sql-compare
Thanks for letting me know. There's already a request for this very feature in the top 20, though it's 7 years old. I'm guessing me voting on it is going to make zero difference in that feature's priority. Oh well. https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/3463480-ignore-default-x-column-constraints / comments
Tianjiao_Li said:
Unfortunately what you are asking is not possible and it can't be achieved using filter either as filters only apply at the object/table level.Can you please leave it on our...
Tianjiao_Li said:
Unfortunately what you are asking is not possible and it can't be achieved using filter either as filters only apply at the object/table level. Can you please leave it on our user voice forum? https://redgate.uservoice.com/forums/141379-sql-compare
Thanks for letting me know. There's already a request for this very feature in the top 20, though it's 7 years old. I'm guessing me voting on it is going to make zero difference in that feature's priority. Oh well. https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/3463480-ignore-default-x-column-constraints / comments
Tianjiao_Li said:
Unfortunately what you are asking is not possible and it can't be achieved using filter either as filters only apply at the object/table level.Can you please leave it on our...
Tianjiao_Li said:
Unfortunately what you are asking is not possible and it can't be achieved using filter either as filters only apply at the object/table level. Can you please leave it on our user voice forum? https://redgate.uservoice.com/forums/141379-sql-compare
Thanks for letting me know. There's already a request for this very feature in the top 20, though it's 7 years old. I'm guessing me voting on it is going to make zero difference in that feature's priority. Oh well. https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/3463480-ignore-default-x-column-constraints / comments
Tianjiao_Li said:
Unfortunately what you are asking is not possible and it can't be achieved using filter either as filters only apply at the object/table level.Can you please leave it on our...
Tianjiao_Li said:
Unfortunately what you are asking is not possible and it can't be achieved using filter either as filters only apply at the object/table level. Can you please leave it on our user voice forum? https://redgate.uservoice.com/forums/141379-sql-compare
Thanks for letting me know. There's already a request for this very feature in the top 20, though it's 7 years old. I'm guessing me voting on it is going to make zero difference in that feature's priority. Oh well. https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/3463480-ignore-default-x-column-constraints / comments
Tianjiao_Li said:
Unfortunately what you are asking is not possible and it can't be achieved using filter either as filters only apply at the object/table level.Can you please leave it on our...
Tianjiao_Li said:
Unfortunately what you are asking is not possible and it can't be achieved using filter either as filters only apply at the object/table level. Can you please leave it on our user voice forum? https://redgate.uservoice.com/forums/141379-sql-compare
Thanks for letting me know. There's already a request for this very feature in the top 20, though it's 7 years old. I'm guessing me voting on it is going to make zero difference in that feature's priority. Oh well. https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/3463480-ignore-default-x-column-constraints / comments
Tianjiao_Li said:
Unfortunately what you are asking is not possible and it can't be achieved using filter either as filters only apply at the object/table level.Can you please leave it on our...
Tianjiao_Li said:
Unfortunately what you are asking is not possible and it can't be achieved using filter either as filters only apply at the object/table level. Can you please leave it on our user voice forum? https://redgate.uservoice.com/forums/141379-sql-compare
Thanks for letting me know. There's already a request for this very feature in the top 20, though it's 7 years old. I'm guessing me voting on it is going to make zero difference in that feature's priority. Oh well. https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/3463480-ignore-default-x-column-constraints / comments
Tianjiao_Li said:
Unfortunately what you are asking is not possible and it can't be achieved using filter either as filters only apply at the object/table level.Can you please leave it on our...