Answers to questions about DB Pro
I recently did 9 Team Edition for Database Professional launch events in 9 different cities (in 3 weeks - yikes!). As I told all of the attendees, I would gather all of the unanswered questions, and post the answers to them on my blog. I actually got REALLY lucky - at the last event (in Houston), someone from the product group showed up - Robert (I have no idea what is last name is - but thanks Robert!). Robert knocked out all of these questions for me, so the only reason it has taken so long to post them is because of me.... anyway - here goes:
For Reporting Services, OLAP, SSIS, DTS support, there isn't any better answer than "not at this time" :-)
Can I migrate a VS2003 Database Project up to new one?
--Import the sql scripts, or deploy and reverse engineer
How does it handle a encrypted stored proc?
--you need to have the original (unencrypted) SPROC in source countrol and deploy it as encrypted
If i have multiple DBProjects, will refactor look in them?
--NO
If I have one SPROC that hits another DB, does that build? if not, how do I work around it?
--In local instance, you'll need to create a linked server so that compile works (shows warnings then instead of errors)
For cross DB call, how are those handled during build/compare?
--will still receive a warning, if for example the linked server reference is resolved
What order are post-deployment scripts run?
--in order that they are included
What if I am developing on SQL2000, what needs to be installed on my machine?
--SQL 2005 instance for the project system + Team Data
What happens if I open the solution with a dbproj on a machine with VS not DBPro?
--The solution will load however you won't be able to access / use the dbproj project; same behavior if you didn't have C# installed and the solution contained a C# project
If I have project/solution in SQL Mgmt Studio, can I move that over easily?
-- Recommend importing / reverse engineer the database vs. import each script into the database project
If i create folders in my project will it build correctly?
-- yes; you can add files & folders to the project; files have a build property to determine if they are to be included in the build process
Can i write my own test validation conditions?
-- yes
In the future, will Team Test allow running db unit tests?
-- This is when the user doesn't have team data - Not today as the generated code inherits from our unittest assembly.
Does "skip" on schema compare change depoy script?
-- yes, it would not include any information in the schema compare deploy script for that object
If I use "description" in a table or column in SQL Mgmt Studio - how can I make use of that?
-- if this is the extended properties, they will be imported as part of reverse engineering a database into the db project