Declarative Database Development

re: Declarative Database Development

swoolhead — Sat, 06 Jun 2009 15:47:43 GMT

I love this tool but find I still have to resort to generating pre vetted scripts due to issues with standing data. For example if I add a NOT NULL field (with a default) to an existing table that has a foreign key constraint to second table, I have to manually create the second table first and populate it with data before I can run this tool. Are there any plans to include standing data into the model?

re: Declarative Database Development

gertd — Sat, 06 Jun 2009 20:33:12 GMT

In the GDR R2 release this should work, at least I have not run in to this restriction using that version. We did run in to this on 2008 RTM and before.

Daily tech links for .net and related technologies - June 7, 2009

Sanjeev Agarwal — Sun, 07 Jun 2009 12:15:17 GMT

Daily tech links for .net and related technologies - June 7, 2009 Web Development Implementing Incremental

re: Declarative Database Development

bayrak — Tue, 21 Jul 2009 23:41:28 GMT

Introducing such a topic you'd like to congratulate you've let us know. Have good work.

re: Declarative Database Development

ScottA — Mon, 17 Aug 2009 15:17:35 GMT

What I looking for is some information on how to make this great tool work where the big push is to control the schema in a data modeling tool such as ERWin or ERStudio. From a company standpoint they are unwilling to budge and let something like this become the development paradigm unless a modeling tool can be incorporated as part of the development tool kit.

re: Declarative Database Development

Grant — Mon, 09 Nov 2009 23:48:33 GMT

Is there some way we can re-synchronize our database source files in the project with the currently implemented database. Our source files are out of sync with the database due to missing keys so we can't rebuild. We also can't perfrom a schema comparison due to the "invalid state error"?

re: Declarative Database Development

Dendrimer — Mon, 09 Nov 2009 23:51:48 GMT

re: Declarative Database Development

gertd — Tue, 10 Nov 2009 02:15:37 GMT

Q: Is there some way we can re-synchronize our database source files in the project with the currently implemented database. Our source files are out of sync with the database due to missing keys so we can't rebuild. We also can't perfrom a schema comparison due to the "invalid state error"?

A: Yes you can use Schema Compare to compare the database with the project, by making the project the target (right hand side) of the comparison, you can update the project (source code) with the changes made inside the database.

re: Declarative Database Development

Siddharth — Tue, 17 Nov 2009 12:45:24 GMT

We are looking at using the features of Datadude for dynamic deployment. Is it possible to compare two database schemas at run-time and generate a deployment script accordingly through code?

re: Declarative Database Development

gertd — Wed, 18 Nov 2009 00:17:53 GMT

Q: We are looking at using the features of Datadude for dynamic deployment. Is it possible to compare two database schemas at run-time and generate a deployment script accordingly through code?

A: Programmatic deployment is a new ability added to the VS2010 version which is currently in beta, in the 2008 GDR version, at best you can shell out to vsdbcmd.exe