Skip to main content
Solved

ApexSQL Refactor and Software Factory


Lars Berntrop
Sidekick
Forum|alt.badge.img+2
Free tool supporting many styles of code, integrated in SSMS. Users can create and share formatting profiles.

Anybody has experience with leveraging this for uniform SQL coding style and thus easy cooperation between different developers?

Best answer by Robert Jan de Nie

I have started using this tool at my projects and like it very much. It ensures the use of consistent formatting between developers. From what I have experienced it is the best (free) tool to use, due to the SSMS integration.

If you are interested in the config file I use, let me know. For some reason I cannot post it here.

The only thing I haven't solved yet is the alignement of the AND in where clauses. It adds in a tab I personally do not like. 😞
View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

18 replies

Robert Jan de Nie
Thinkwise blogger
Forum|alt.badge.img+5
I have started using this tool at my projects and like it very much. It ensures the use of consistent formatting between developers. From what I have experienced it is the best (free) tool to use, due to the SSMS integration.

If you are interested in the config file I use, let me know. For some reason I cannot post it here.

The only thing I haven't solved yet is the alignement of the AND in where clauses. It adds in a tab I personally do not like. 😞

Frank Wijnhout
Thinkwise blogger
I am using this plug-in too. I completely agree with Robert Jan, also about the "AND-issue".

I use this plug-in a lot when I look at queries from the GUI-debugger.

Jop ter Horst
Vanguard
Forum|alt.badge.img+5
Frank Wijnhout wrote:
I am using this plug-in too. I completely agree with Robert Jan, also about the "AND-issue".

I use this plug-in a lot when I look at queries from the GUI-debugger.


Do you use a certain profile in ApexSQL? If you have one that matches the Thinkwise SQL Conventions, I'd like to recieve it.

Frank Wijnhout
Thinkwise blogger
Here is a formatting that comes close to our SQL Conventions. However, it seems not possible to meet them completely...

Robert Jan de Nie
Thinkwise blogger
Forum|alt.badge.img+5
@Frank Wijnhout how do you add files to your reply? I can do links, but not files 😞

Frank Wijnhout
Thinkwise blogger


Robert Jan de Nie
Thinkwise blogger
Forum|alt.badge.img+5
I dont seem to have that option. @Moller Toma you know what's up?


Moller Toma
Captain
Forum|alt.badge.img+11
@Robert Jan de Nie

Has the problem already been solved?

Please send an e-mail to community@thinkwisesoftware.com in the future.

Lars Berntrop
Sidekick
Forum|alt.badge.img+2
The upload icon is invisible to me.

Robert Jan de Nie
Thinkwise blogger
Forum|alt.badge.img+5
@Moller Toma yes 🙂

Jaap van Beusekom
Vanguard
Forum|alt.badge.img+2
I used PoorMansTSqlFormatter before. This is the real deal I noticed 🙂 Thxs for the tip @Lars Berntrop

.. and uhhh no upload icon for me to @Moller Toma 😙

Moller Toma
Captain
Forum|alt.badge.img+11
@Jaap van Beusekom I'm in discussion with the supplier to see what's going on.

Moller Toma
Captain
Forum|alt.badge.img+11
The problem due to upload icon is solved

Jasper
Superhero
  • 678 replies
  • March 14, 2019
@Jaap van Beusekom We have looked at PoorMansTSqlFormatter in the past, but its AGPL license prohibits the use of this library in non-AGPL software.

However, Apex is working on a CLI for the ApexSQL Refactor 2019 version. We will definitely keep an eye on this!

Jaap van Beusekom
Vanguard
Forum|alt.badge.img+2
@Jasper PoorManTSqlFormatter? What's that? 😁

Robert Jan de Nie
Thinkwise blogger
Forum|alt.badge.img+5
Another SQL formatter. Maybe for poor people? 😁

I have tried that one as well, but found apex to work better for me. Also I don't know if it can be integrated in SSMS.

Jasper
Superhero
  • 678 replies
  • March 14, 2019
Jaap van Beusekom wrote:
I used PoorMansTSqlFormatter before.


Jaap van Beusekom wrote:
@Jasper PoorManTSqlFormatter? What's that? 😁


@Jaap van Beusekom 😕

Dave Bieleveld Starcode
Vanguard
Forum|alt.badge.img+2

@Robert Jan de Nie @Frank Wijnhout 

 

It appears that ApexSql formatter is now integrated in ApexSql Sql Server tools and the pricing is not known (you need to request a custom pricing).

Do you guys still use it, or have you transitioned to another formatting tool? 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings