VSTS4DBP import script gotcha

While importing a DDL script recently, I encountered the following gotcha:
DimCustomerBadFormatted
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:
DimCustomerWellFormatted
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:

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: