Comment Feed for New GDR Announced for Visual Studio Team System 2008 Database Edition (briankel on Channel 9)

Re: New GDR Announced for Visual Studio Team System 2008 Database Edition

luckyzhu — Mon, 26 Oct 2009 03:36:06 GMT

Tiffany jewelry has been an incontrovertible perfect gift idea. Here we have hundreds of cheap and discounted tiffany silver jewelry including tiffany rings(tiffany ring), tiffany bangles,tiffany bracelets(tiffany bracelet), pendants, necklaces, charms, tiffany earings, sets, and return to tiffany, tiffany 1837 accessories for your choice. All our jewelry is 925 sliver guaranteed.

Re: New GDR Announced for Visual Studio Team System 2008 Database Edition

Mike — Fri, 23 Oct 2009 18:30:47 GMT

Hopefully your talk will find it's way online at somepoint, sounds just what I need. I have found the DBPro very useful but using the output to louboutin shoes deploy to an end clients system in a nice wrap up installer has always been a stumbling block unlike our connected internal systems which are a breeze.

Re: New GDR Announced for Visual Studio Team System 2008 Database Edition

Gabor Ratky — Tue, 24 Jun 2008 15:31:07 GMT

GertD,

I am looking at the CTP of the GDR right now, but before I dive into, I wanted to specifically ask about better support for CI and not just using Team Build.

I had a day of issues with the OTB VS2008 Database Edition project type on a build machine that had TeamCity running. Most disturbing was the requirement of the registry key for the user that was running MSBuild for the design DB. I have found forum threads discussing this and workarounds that can work but it was still a hassle and without innate knowledge of MSBuild (and sometimes even Reflector :)), this would be really hard.

I'm now considering moving up to SP1 Beta1 and your June CTP and hope for the best, willing to spend another half day being bleeding edge ;) but I still wanted to get the half-technical/half-marketing answer from you on what can we expect in the future.

Here are my current pain points:

- No simple deployment of MSBuild targets, GAC assemblies (Microsoft.VisualStudio.TeamSystem.Data[.Tasks].dll), etc. on build agents. Had to install VS2008 on my build box, even though I wanted to avoid that.
- No way to configure the DB server instance name for the DesignDB through MSBuild properties, registry keys are super ugly under HKCU when my build agent is running under some obscure non-interactive user account. I know this is going away, but is the end-to-end story going to be better.
- MSBuild error messages shouldn't point me to the build properties tab in VS and I wouldn't want to rely on generated .dbproj.user files just to be able to figure out what am I missing.

oh and most importantly, what is the timeframe for the RTM GDR? Can I expect it to be released 1-2 weeks max after SP1 RTM or maybe even earlier?

Thanks,
Gabor

Re: Re: New GDR Announced for Visual Studio Team System 2008 Database Edition

Brian Keller — Mon, 09 Jun 2008 05:54:20 GMT

Moto -

If I had to guess maybe you weren't looking on the 2nd page of comments? Contrary to the conspiracy theories we wouldn't delete your comment just for mentioning IBM. ;-)

Brian

Re: New GDR Announced for Visual Studio Team System 2008 Database Edition

MotoWilliams — Sat, 07 Jun 2008 05:34:46 GMT

Me too, I made a comment before on this thread and it is no longer there. I did mention IBM so I guess maybe they are deleting on mention of other products.

EDIT: 2 seconds later, I guess they didn't remove it, I just couldn't see where it was. Very confusing Channel9'ers.

Re: Re: New GDR Announced for Visual Studio Team System 2008 Database Edition

MotoWilliams — Sat, 07 Jun 2008 05:29:48 GMT

Me too, I made a comment before on this thread and it is no longer there. I did mention IBM so I guess maybe they are deleting on mention of other products.

Re: Re: New GDR Announced for Visual Studio Team System 2008 Database Edition

gertd — Fri, 06 Jun 2008 17:57:46 GMT

Q: In watching the keynote at TechEd, the "GDR release will support DB2". Since DB2 isn't just DB2, can anyone tell us if it will support DB2 on iSeries? (yes there are differences, EF doesn't support DB2 on iSeries)

A: IBM is the only authoritative source to answer, but the way I understand it is that the current implementation targets their DB2 implementations on Windows, Linux and AIX, since it is a shared implementation. They are actively evaluation the need to support the other versions.

-GertD

Re: Re: New GDR Announced for Visual Studio Team System 2008 Database Edition

gertd — Fri, 06 Jun 2008 17:55:00 GMT

I am not sure what you mean with "SQL Server Schema parts" that is a term that I am not familiar with. Please educate me on what this is or means.

With regards to plans to add Oracle support, we cannot make announcements on behalf of other companies. Microsoft will not develop providers for other data stores, but we are working with all major vendors and 3rd parties to make sure all major data stores are covered.

The index that gets dropped in the demo is a bug in the system right now, we only need to update text based objects like functions, default constraints, check constraints etc when renaming a column.

-GertD

Re: New GDR Announced for Visual Studio Team System 2008 Database Edition

MotoWilliams — Thu, 05 Jun 2008 23:06:17 GMT

In watching the keynote at TechEd, the "GDR release will support DB2". Since DB2 isn't just DB2, can anyone tell us if it will support DB2 on iSeries? (yes there are differences, EF doesn't support DB2 on iSeries)

Re: New GDR Announced for Visual Studio Team System 2008 Database Edition

sokhaty — Thu, 05 Jun 2008 16:37:44 GMT

Partial/Composite projects sound very promising. Are you guys planning to add "SQL Server Schema parts" to Windows marketplace any time soon? ;)

Also, any plans to add Oracle support? I've heard about forthcoming DB2 support, but supporting Oracle would be really big.

On a site note, does renaming a column really requires dropping indexes built on it? (At least it looked like column rename in the demo generated drop/create index statements).

Re: New GDR Announced for Visual Studio Team System 2008 Database Edition

scot — Wed, 04 Jun 2008 06:40:37 GMT

Pingback from:Handan

Re: Re: Re: Re: New GDR Announced for Visual Studio Team System 2008 Database Edition

gertd — Wed, 04 Jun 2008 03:29:44 GMT

I will record a Camtasia once I am back in Redmond.
-GertD

Re: New GDR Announced for Visual Studio Team System 2008 Database Edition

Joshua Ross — Wed, 04 Jun 2008 03:17:58 GMT

The quality of the video is wonderful! I'm looking forward to using this product. As a side note, I had a hell of a time trying to get this comment in. Can we go back to the old site?

Re: Re: Re: New GDR Announced for Visual Studio Team System 2008 Database Edition

PerfectPhase — Tue, 03 Jun 2008 23:32:07 GMT

Hopefully your talk will find it's way online at somepoint, sounds just what I need. I have found the DBPro very useful but using the output to deploy to an end clients system in a nice wrap up installer has always been a stumbling block unlike our connected internal systems which are a breeze.

Re: Re: New GDR Announced for Visual Studio Team System 2008 Database Edition

gertd — Tue, 03 Jun 2008 19:33:39 GMT

The deployment engine is two .NET assemblies, one core and one provider assembly.

However there is no direct way to run managed custom actions from an installer, which is what you would have to write to make this work. The reason why the installer folks do not like this is the unexpected behavior if you load mixed version assemblies from the same host.

The supported way will be to run a command line version from a custom action in WiX. We will provide a command line shell, vsdbcmd.exe, which will be able to deploy a .DBSCHEMA file. I will be demonstrate this on Friday at TechEd in my session TLA320.

-GertD

Re: New GDR Announced for Visual Studio Team System 2008 Database Edition

PerfectPhase — Tue, 03 Jun 2008 15:50:52 GMT

Intreasting stuff. A quick question, I use this for developing the database for one of our more shrink wrap type of applications, will I be able to use the deployment engine in a WiX based installer?