VSTS4DBP import script gotcha

While importing a DDL script recently, I encountered the following gotcha:

My imported script was not formatted correctly as it is when I import the objects from database. To correct the formatting, first I had to deploy the objects to the database. Second, I deleted objects from my project. Finally, by doing a schema comparison between the database and the project, I was able to re-import the database objects. This time, the scripts were both correctly formatted and stripped:

This gotcha did not prevent the project to properly deploy nor did it caused VSTS4DBP to malfunction. I found it more annoying to have scripts formatted differently in my DB project. It is also worth mentioning that this also happens when a column is renamed; if the new name’s length is different than the previous one,the script format will not be adjusted and the columns will be misaligned.
Christian

Labels: VSDB