Menu
Tool aims to bridge DBA-developer gap

Tool aims to bridge DBA-developer gap

Microsoft says its upcoming database development tool will help application developers and database administrators collaborate better.

Visual Studio 2005 Team Edition for Database Professionals, to be released to manufacture on 30 November, is one of the four modules comprising the company's Visual Studio 2005 Team Edition suite of developer tools.

"There are people building apps and people building databases. Depending on your organisation, they can be warring tribes," says Cameron Skinner, product manager for the Database Professionals software. "We are trying to solve the collaboration problem and give folks some tooling to get control over their database schema changes."

Skinner says the tool can help database administrators visually compare data and then generate scripts to easily move it from one place to another. For database developers "slinging T-SQL code, writing triggers and such, they will also find lots of good things here," he says.

Skinner says the tool and the Visual Studio suite is unique among the large database vendors. "Oracle and IBM have point solutions, but not something that is part of an overall software lifecycle management suite," he says.

He also says the software, which lists for US$5000 per user license, should be easy to learn. "If you've never seen Visual Studio, there's a learning curve, but it should be easy for .Net and Visual Studio programmers," he says.

Gulf Coast Seal, a Houston-based distributor of industrial products for energy producers, used beta versions of Visual Studio for Database Professionals to revamp its SQL Server 2005-based data warehouse, Extract, Transform and Load (ETL) process and business reports.

Previously, according to Jeff Lynch, e-commerce manager at Gulf Coast Seal, changes were done "ad-hoc, without the benefit of source control, unit testing or any proper build procedure. If we forgot to backup the test database and changed something which broke several functions and sprocs, it took hours and hours to find and fix."

Using the software, Gulf Coast was able to create an off-line copy of its database and set up a "sandbox" area for development and testing, sharply cutting deployment time, Lynch says.


Follow Us

Join the newsletter!

Or

Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.

Tags Microsoft

Events

Featured

Slideshows

Meet the Reseller News 30 Under 30 Tech Awards 2020 winners

Meet the Reseller News 30 Under 30 Tech Awards 2020 winners

This year’s Reseller News 30 Under 30 Tech Awards were held as an integral part of the first entirely virtual Emerging Leaders​ forum, an annual event dedicated to identifying, educating and showcasing the New Zealand technology market’s rising stars. The 30 Under 30 Tech Awards 2020 recognised the outstanding achievements and business excellence of 30 talented individuals​, across both young leaders and those just starting out. In this slideshow, Reseller News honours this year's winners and captures their thoughts about how their ideas of leadership have changed over time.​

Meet the Reseller News 30 Under 30 Tech Awards 2020 winners
Reseller News Exchange Auckland: Beyond the myths — how partners can master cloud security

Reseller News Exchange Auckland: Beyond the myths — how partners can master cloud security

This exclusive Reseller News Exchange event in Auckland explored the challenges facing the partner community on the cloud security frontier, as well as market trends, customer priorities and how the channel can capitalise on the opportunities available. In association with Arrow, Bitdefender, Exclusive Networks, Fortinet and Palo Alto Networks. Photos by Gino Demeer.

Reseller News Exchange Auckland: Beyond the myths — how partners can master cloud security
Reseller News welcomes industry figures at 2020 Hall of Fame lunch

Reseller News welcomes industry figures at 2020 Hall of Fame lunch

Reseller News welcomed 2019 inductees - Leanne Buer, Ross Jenkins and Terry Dunn - to the fourth running of the Reseller News Hall of Fame lunch, held at the French Cafe in Auckland. The inductees discussed the changing face of the IT channel ecosystem in New Zealand and what it means to be a Reseller News Hall of Fame inductee. Photos by Gino Demeer.

Reseller News welcomes industry figures at 2020 Hall of Fame lunch
Show Comments