Re: VS2008 DBE (GDR)

Thanks for the response; however your answer doesn't address the issue as I
wasn't completely clear in my original post. Let me try to clarify.

I am developing a database and the results of my efforts will eventually be
deployed to other developers. (In fact I'm sending out the deployment
script (sql) on a daily basis to other developers.)

I use a SQL2005 database instance as a development database; i.e., I add
tables, columns, indexes, etc. as development proceeds. I also have a DBE
project set up in VS2008 and I periodically update the DBE database
representation there using the Schema Compare function.

Now the database itself will (or should be) empty EXCEPT for a few lookup
tables that contain data that should be in the database when it is deployed.
In other words, when the other developers use my delivered script, they
expect the resulting database to already have populated lookup tables.

Currently, as I said above, I use the Schema Compare function to update the
DBE project representation of the database; however the "write updates"
function does *not* include any of the data. (This isn't surprising given
that I'm doing a *schema* compare and update.)

So, I guess the first question is how do I get the *data* from a database
instance into the DBE project somewhere? I assume this would take the form
of Sql Inserts or some such. Currently I'm doing this by hand, but as the
number of lookup tables (and table entries) grows this becomes very tedious.

Second question is, given that I have the necessary data loading scripts,
how do I incorporate them into the deployed SQL file? I notice there are
comments in the generated script that refer to pre and post deployment
scripts, but I'm afraid that if edit the deployment script my edits will
simply be overwritten next time I deploy and the file is regenerated.
Currently I distribute the data loading script as a second script to run,
but that doubles the work of the other developers (who don't even like to
run *one* script!)

I think that's it:

First question - How to get data from database into DBE structure?
Second question: How to get the data loading scripts into the deployment
script?

I hope this clarifies my original question.

Thanks,
Bill

PS - thanks for passing along my question about receiving emails when
postings occur. Your respons post BTW also did NOT generate an email
notification.


""Hongye Sun [MSFT]"" <hongyes@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:hdAY6X1tJHA.1636@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi Bill,

Thanks for your post. I am Hongye Sun [MSFT] and it is my pleasure to work
with you. Since Visual Studio is my speciality, so I take this issue from
Colbert.

If my understanding is correct, you want to deploy database project to a
target database, which already has data in some lookup tables. Please let
me know if anything missing here.

First, please make sure that the following settings are setup correctly:

Right click on project file in Visual Studio, select properties, select
Deploy tab in properties page.
1. Check Deploy action is "Create a deployment script (.sql) and deploy to
the database"

2. Check Target database settings are set correctly

At Deployement configuration file, click Edit Button
3. Make sure "Block incremental deployment if data loss might occur" is
unchecked
I assume that the data in lookup database will be regenerated in your
script file.

4. Check "Always re-create database", if the data in the target project is
not required to be preserved.

If you do not check the options in 3 and 4, there will be errors when you
deploy a dbproject to an existing database.

Second, if you have already configured all the settings above, you still
can't deploy to the target dabase. You should look into the error logs in
the output window. Please alo copy them here.

For the newsgroup notification issue, I have forwarded your issue to
proper
internal channel to handle. If I get any updates, i will let you know.

Regards,
Hongye Sun (hongyes@xxxxxxxxxxxxxxxxxxxx, remove 'online.')
Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msdnmg@xxxxxxxxxxxxxx

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within?2 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions. Issues of this
nature are best handled working with a dedicated Microsoft Support
Engineer
by contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx
==================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.



.

Loading