CTP5 -- Question
We are looking at what we will put into CTP5 and as we consider this a question arrises. This release may depend on having an instance of SQL Developer Edition installed on the local machine(currently we require SQL Express). However, SQL Dev edition by itself is a large download and presents setup callenges. What we would like to have you do is the following:
- Install VSPro or higher (should already be done if you are using our current CTPs
- Install SQL Dev Edition (if you have VS Pro or better you have the disk already to do this but have to run it separate from the VS setup).
- Run VSTE4DBPro CTP setup to install our bits
- Edit your VS configuration to point at the SQL Dev Edition instance, ie: Tools -> Options -> Database Tools -> Data Connections and change the SQL Server instance name to your SQL Dev
You can do this currently with CTP3 and CTP4. It becomes more important as we continue to fill out our parser/interpretter because it means we can use this instance to validate any enterprise constructs that you utilize. SQL Express doesn't support partition schemas and other Enterprise features but SQL Dev does. Thus if you have a project that utilizes any of these features when we call the sql instance to validate the sql code, the database (if SQL Express) would tell us that it is invalid syntax.
I would love a more "automated" install experience but I want to keep the download size manageable so let me know how this would work for you.
