Every once in awhile I get the opportunity to write an application that is important enough to do, but not important enough to do the right way -- meaning standards, best practices, good architecture, et al. I call it lazy coding. The industry calls it RAD (rapid application development). I started on the conversion tool at the end of last week. It will convert our legacy data to a completely new system which I'm working on piece by piece. It will be used in the future, but only the new parts because ......
When you add SQLCMD statements to a pre-deployment or post-deployment file in a database project in Visual Studio 2010. You might see the error "SQL80001: Incorrect syntax near ':'". This is not a real error assuming you have the correct SQLCMD syntax.
To clear the errors temporarily right click on the document and select SQLCMD mode.