Comments
Sort by recent activity
Hi @Ivar,
speaking about sharing stuff across RedGate tool is actually a trend topic in latest weeks ;-)
I hope to get everything under a "central" point, but, until then, I've moved those files (not just tabs, but also coding styles and so on) under source control, in a certain folder. Then, I've changed the default path of each tool in order to read from that source controlled path, and that's it.
If you don't have default paths or if you cannot change the path setting, you can use powershell (or similar) in order to automate the copy of that file (from your machine for instance) into the source control. Then, when you get, you can execute another posh that synchronize each member of the team.
It's just a big picture, 'cause I really want to share with you the automation/devops "approach". Then you can choose everything you consider into your comfort zone.
cheers,
ale / comments
Hi @Ivar,
speaking about sharing stuff across RedGate tool is actually a trend topic in latest weeks ;-)
I hope to get everything under a "central" point, but, until then, I've moved those files (n...
hi jrbrown00,
did you mean SQL Compare (not SQL Data Compare)?
anyway, you can exclude objects using filters: https://www.red-gate.com/hub/product-learning/sql-compare/sql-compare-custom-filters
hope this helps / comments
hi jrbrown00,
did you mean SQL Compare (not SQL Data Compare)?
anyway, you can exclude objects using filters: https://www.red-gate.com/hub/product-learning/sql-compare/sql-compare-custom-filters
ho...
hi @...,
not by design. But you can automate the process using the command lines as described here:
SQL Compare command line
Sql Data Compare command line
/ comments
hi @...,
not by design. But you can automate the process using the command lines as described here:
SQL Compare command line
Sql Data Compare command line
Hi @Jacco,
the rules are stored in `C:\Users\<youruser>\AppData\Roaming\SqlCodeGuard30` as a XML file. You can write a PowerShell in order to copy that file in a shared environment (a source control or else a cloud storage, like Google drive/One drive/Dropbox). Then, everyone must copy that file in its `C:\Users\<itsuser>\AppData\Roaming\SqlCodeGuard30` folder.
I didn't find any "default location" for that XML file. I'd like to change it to set the shared folder, but I couldn't find anything about this setting.
For the moment, we're getting the XML setting file and copying it on a git repo. Then, every team member executes a PoSh script in order to put the file into its user folder. / comments
Hi @Jacco,
the rules are stored in `C:\Users\<youruser>\AppData\Roaming\SqlCodeGuard30` as a XML file. You can write a PowerShell in order to copy that file in a shared environment (a source contro...
hi EsioNunes,
what is the style you're using when formatting? / comments
hi EsioNunes,
what is the style you're using when formatting?
hey @gardner358
we have had the same problem. You've to navigate to the `%LOCALAPPDATA%\Red Gate\SQL Prompt x` (where x is your previous version) and copy the `SavedTabs.db` file into the new folder (SQL Prompt 9). It worked on my side.
hope this helps / comments
hey @gardner358
we have had the same problem. You've to navigate to the `%LOCALAPPDATA%\Red Gate\SQL Prompt x` (where x is your previous version) and copy the `SavedTabs.db` file into the new folde...
Hi @jakkir,
could you please try to check the log file and send us the content? / comments
Hi @jakkir,
could you please try to check the log file and send us the content?
Yes, got it.
However, you can call sp_executesql with param names: EXECUTE sys.sp_executesql @stmt = N'SELECT * FROM dbo.Countries WHERE CountryName = @p0;'
, @params = N'@p0 VARCHAR(100)'
, @p0 = 'USA';
at least, starting from 2008: [image] / comments
Yes, got it.
However, you can call sp_executesql with param names:EXECUTE sys.sp_executesql @stmt = N'SELECT * FROM dbo.Countries WHERE CountryName = @p0;'
, @params = N'@p0 VARCHAR(100)'
, @p0...
hay @buinauskas,
I guess you're speaking about SQL Prompt 9 Rules. You can uncheck the following rule in order to avoid the "issue". It's up to you to manage what rules you'd like to consider. It's not a bug "to be fixed" IMHO. [image] / comments
hay @buinauskas,
I guess you're speaking about SQL Prompt 9 Rules. You can uncheck the following rule in order to avoid the "issue". It's up to you to manage what rules you'd like to consider. It's...
hey @davidsumlin
in order to move the AND right under the WHERE statement you've to set the "Alignment" property, under Operators, to "To Statement": [image] / comments
hey @davidsumlin
in order to move the AND right under the WHERE statement you've to set the "Alignment" property, under Operators, to "To Statement":