Data Dude + Developer Edition = Team Developer

יום שלישי, ספטמבר 30, 2008

{From My VSTS KB} In today's press release titled: "Visual Studio 2010 and .NET Framework 4.0 Overview" MS also announced the merge of the Developer Edition and Database Edition SKU's. From Gert’s post: What does this mean? In the next release of Visual Studio Team System we will be merging the feature sets of the Development Edition and the Database Edition into a single product. The new product – part of Visual Studio Team System codename “Rosario” – will include all of the features in the Development Edition and the...
אין תגובות

Data Dude:Deploy Action On CTP16 Does Not Deploy The Database To Target

יום שבת, ספטמבר 27, 2008

A lot of users confused and don’t understand why the database does not appear on the target server when they do deploy. The reason is that in CTP 16, the default deploy mechanism is to deploy to script. If you want to deploy to database you have to change the 'Deploy action' on the project properties, deploy tab to 'Create a deployment script (.sql) and deploy to the database.' Read more.
2 תגובות

Data Dude On RadioTFS

יום שלישי, ספטמבר 16, 2008

From http://vstskb.net - http://feeds.feedburner.com/~r/vstskb/~3/394424099/ Just published over on Radio TFS  a special episode on the Database Edition of Team System with the Data Dude man - Gert Drapers.  In the show Gert talks how the product got started, where it is now, where it is going in the future, the latest CTP of the Database Edition GDR and more.
אין תגובות

VSTSDB 2008 GDR CTP16

יום שישי, אוגוסט 29, 2008

Gert just posted about the release of CTP16 of the Visual Studio Team System 2008 Database Edition GDR release. From Gert’s post: This release adds the following features: VSDBCMD.EXE We added independent commandline deployment and reverse engineer, which can be used on machines that do not have Visual Studio installed, in order to deploy the results of a database project build (.dbschema file), or if you need to generate a .dbschema file so you can for example compare it,...
אין תגובות

CTP15 of the GDR release of VSTSDB is available

יום שלישי, יולי 22, 2008

Gert just announced that they just released a new CTP of the upcoming 2008 update, Microsoft® Visual Studio Team System 2008 Database Edition GDR. You can download it from MSDN: http://www.microsoft.com/downloads/details.aspx?FamilyID=bb3ad767-5f69-4db9-b1c9-8f55759846ed&displaylang=en Most important changes: Project upgrade is now in place. Mixed projects are no longer supported, from now on server projects represent only server creatable objects and user objects that need to be deployed to “master”. Another change is that server options will not get deployed; we only validate the settings as pre-requisites for...
אין תגובות

VSTS 2008 Database Edition GDR – Where Is The Properties Tabs?

יום חמישי, יוני 12, 2008

Some changes were shipped in the last GDR June CTP of VSTS 2008 Db Pro. If you want to change or view the catalog properties, deployment properties or variables properties you should navigate the properties node. These properties tabs are no longer exists under the database properties area. Example: When you click for example on the CatalogProperties.catalogproperties property, the database properties will be displayed.
אין תגובות

VSTS 2008 Database Edition GDR June CTP

יום רביעי, יוני 4, 2008

Yesterday, at TechEd 2008 Developer, Data Dude team announced the immediate availability of the first public CTP of the Visual Studio Team System 2008 Database Edition GDR (General Distribution Release). The GDR is available now for download but before you install it, make sure read the installation requirements. If you have DBPro Power Tools installed, uninstall it first. AND you'll need to have Visual Studio 2008 Service Pack 1 Beta installed From Gert's post: What is in the GDR? In addition to enabling SQL Server 2008 database projects, the GDR release incorporates many of the previously released Power Tools functionality as well as...
אין תגובות

VSTS Database Professionals msdb Projects

יום חמישי, מאי 15, 2008

You can now download the sample msdb database projects from Microsoft Code Gallery to create cross database references between your database project schema objects and the schema objects that reside within the msdb database. There are msdb database projects for both Visual Studio Team System 2008 release of Database Edition as well as the Visual Studio Team Edition 2005 for Database Professionals Service Release 1 for both SQL Server 2000 and SQL Server 2005. Cross-database references requires that you define a corresponding reference in the properties of your database project. If you refer to objects...
אין תגובות

Permissions Error when Creating Database Projects

יום שני, אפריל 28, 2008

Recently I got a question about permissions error that occurred when user was trying to create database project in the local instance of Microsoft SQL Server used for design-time validation. The error was: "CREATE DATABASE permission denied in database 'master'". Workaround To create database you must be a member of the dbcreator and securityadmin fixed server roles in the server instance that you specified for design-time validation. First, ensure that the instance name that is specified for your design-time validation database is correct. Second, a user with sysadmin permissions should run the following script on...
אין תגובות

How To Deploy Data Dude Project Changes using Team Foundation Build

When you want to build and deploy database projects with team build you need to edit the database project file and the Team Build file. That's because database projects store any non-default values for the TargetDatabase, TargetConnectionString, and DefaultDataPath properties in a <ProjectName>.dbproj.user file.  *.user files are not checked into version control in order to let every user use different values.   Step 1 - Modify build project file (team build .proj file) Open the BuildDefinition.proj file, and at the bottom of the file, between the </ItemGroup> element and the </Project> element, add the following: ...
אין תגובות