Deborah's Developer MindScape

The new Visual Studio 2010 Database Project, as described in this prior post , makes it easy to work

Hiiiiiiiiiii everyone ,

I like your site as well as your blog as it had provided a good information on the technology.

============

Susan

<a href="http://compareisas.org.uk" rel="dofollow">Compare ISAs</a>

The new Visual Studio 2010 Database Project, as described in this prior post , makes it easy to work

The new Visual Studio 2010 Database Project, as described in this prior post , makes it easy to manage

The new Visual Studio 2010 Database Project, as described in this prior post , makes it easy to work

Interesting Finds: May 3, 2010

Hey there,

We've tried to use Database Projects in the past but ran into circular dependency issues. Our SqlServer has a dozen databases with lots of sprocs/udfs that perform cross database joins, selects, inserts, etc.

The problem happens when Database A is "compiling" and it references Database B which causes Visual Studio to "compile" Database B which has a reference to Database A... rinse and repeat. Circular.

Does Visual Studio 2010 handle circular references more effectively? Other than getting rid of the circular references (which I'd love to do, if possible), do you have any suggestions?

Thanks.

-k

I didnt get this as part of the install - damn I knew I should have chosen install everything (even though I really didn want to) - so what should I check to include these templates when doing a new install?

I also thought I didn't have the templates installed.  If I clicked on 'Database', the list to the right would say, "No Items Installed" or something like that.  However, clicking the small navigational arrow to the left of the word 'Databases' opens the child menu 'SQL Server'.  That's where all the templates are.  Maybe you're having the same problem.  Hope this helps.

There is any way to make it dumb again?

I only want to store my scripts.

Hi "-k"

I think it could be helpful - MSDN link "Starting Team Development of Databases that Reference Other Databases"

msdn.microsoft.com/.../dd193279.aspx

Good luck

G.

Deborah: What I really miss from the old DB Project, is that every script in that project will run against the database selected for the project.

Now I have to Connect to the Server and then select the correct DB (or have "USE XX" in every script)

It is possible to have circular references in database projects: Read up on "Partial Project References". Essentially, you can export part of a project as a file and reference it from another project, which allows that project to resolve references.

Deborah: I'm not sure which part or the post are you referring.

I've changed the deployment setting and setup the target database (scared as hell), but the script do not connect automatically to that DB when I opened them in VS2010.

Missed something?

Thanks Deborah, it's clear now.

I'm not into automatic deploying scripts, so it's useless to me.

But thanks anyway.

And now in top of bad news: The editor can't connect to SQL 2000!!

Aglight.cz – blog o WPF a SL v češtině Nejlepší programy pro vylepšování HTML kódů – přehled validátorů,

Hi Debs, thanks so much for these very informative articles. I've just migrated to VS2010 and the new dbproj throws a few spanners in the works for me but I can see with a different approach it can really make life a lot easier. Your articles have provided an easy and quick way to get up to speed, thanks again!

VS 2010 Database projects - treat your database as code

I see where you can execute a stored procedure in order to store it in the database , but in the old database projects you could also run the stored procedure - is this also gone

Deborah,

We have been trying to use a database project in our enterprise application (VS 2010 and SQL Server 2008 R2).  However, doing a schema compare and write changes results in the generation of horrific scripts.  

For example,

CREATE TABLE [dbo].[LabGroups] (

   [LabGroupUid]          UNIQUEIDENTIFIER NOT NULL,

   [FK_ParentLabGroupUid] UNIQUEIDENTIFIER NULL,

   [FK_LabGroupLeaderUid] UNIQUEIDENTIFIER NULL,

   ALTER TABLE [dbo].[LabGroups]

   ADD [LabGroupCode] NVARCHAR (20) NOT NULL;

,

   [LabGroupName]         NVARCHAR (120)   NOT NULL,

   [IsLab]                BIT              NOT NULL,

   [Created]              DATETIME         NOT NULL,

   [CreatedBy]            NVARCHAR (50)    NOT NULL,

   [Modified]             DATETIME         NOT NULL,

   [ModifiedBy]           NVARCHAR (50)    NOT NULL

);

We get large regions of the scripts commented randomly and also odd mixtures of CREATE and ALTER <object> as in above ... my database guy is spending hours to fix the scripts after every compare.

Have you seen anything like this?

Nice article!

Question:  Internally, I plan to use a 2008 database project.  However, several of my customers still use 2005.  Will a dbschema built with a SQL Server 2008 project be able to update a 2005 database out in the wild with VSDBCMD.exe?

Thanks.