Sample Header Ad - 728x90

How to cope with SQL Server 2012 vs SQL (Azure) Database sql files

2 votes
1 answer
173 views
I'm trying to port my system to SQL Database (Azure instance) from SQL Server 2012. I'm using Visual Studio 2013 and I have my .sqlproj with all the definition of my database inside. Given that a number of SQL statements are not available in SQL Database (like "ON [PRIMARY]", filegroups, etc.), I should change a huge number of *.index.sql , *.pkey.sql, *.table.sql files. Unfortunately I still need to cope with SQL Server 2012 installations (some customers are still on that infrastructure), so I would like to have instead a simple way to switch between the "SQLAzure" vs. "OLD-2012" syntax. E.g. something like Compilation Symbols would be useful, or similar tricks. Anyone has a brilliant idea on how to manage such an issue? Thank you very much! cghersi
Asked by Cristiano Ghersi (221 rep)
Aug 11, 2014, 11:41 PM
Last activity: Nov 12, 2020, 06:02 AM