SQL Prompt formating vs Visual Studio Schema Compare
redgateUser288
Posts: 2
Hi there,
I use SQL Prompt 7.1 to format my sql code within visual studio, for deployment we are using SSDT. On the database projects in Visual Studio I often use Schema compare, however the formatting from SQL Prompt doesn't match with the formatting that is used on the sql server when the schema compare shows the objects. Therefore for the schema compare often objects are not equal just because some code formatting. How can I fix this ?
I use SQL Prompt 7.1 to format my sql code within visual studio, for deployment we are using SSDT. On the database projects in Visual Studio I often use Schema compare, however the formatting from SQL Prompt doesn't match with the formatting that is used on the sql server when the schema compare shows the objects. Therefore for the schema compare often objects are not equal just because some code formatting. How can I fix this ?
Comments
I think to achieve this you'll either need to format the objects on your database in the same style as your scripts or vice-versa.
If you want to format the objects in the database using SQL Prompt you could script them as ALTER, then format that script and run it against the database.
Alternatively you could try the new 7.3 beta formatter to see if you can create a style to match the style currently used in the database and format your local scripts using that.
Thanks,
Aaron.