Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Doesn't the IDE force you to update your data generation plan if your schema changes anyway?</p> <p><a href="http://msdn.microsoft.com/en-us/library/aa833256(VS.80).aspx" rel="nofollow noreferrer">From the MSDN</a>:</p> <blockquote> <p>When you create a data generation plan in a database project, the plan is based on the database schema of the project. If you create a data generation plan and then the schema of the database project changes, you are prompted to update the plan. This behavior occurs in the following cases:</p> <ul> <li>You create a data generation plan in a database project that does not have a schema yet. You then import a schema into the database project.</li> <li>You create a data generation plan in a database project that has a schema, and then the schema changes.</li> </ul> <p>In both cases, you are prompted to update the data generation plan when you open it or when it becomes the active document. If you do not update the data generation plan based on the schema changes, you cannot continue to edit the plan. You can close and reopen the data generation plan to display the prompt again.</p> </blockquote> <p>More evidence from <a href="http://blogs.msdn.com/gertd/archive/2008/02/14/data-generation-wizard.aspx" rel="nofollow noreferrer">a blog</a> on this subject:</p> <blockquote> <p>... the schema of the objects inside the database has to match the table inside the database project.</p> </blockquote> <p>I guess you could dig into the *.dgen file and do a pre-build step (or something similar) that would ensure it always matches your DB schema. Maybe that would automate things enough.</p>
    singulars
    1. This table or related slice is empty.
    1. POVisual Studio Data Generation Plan Schema Update
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USJohn
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POVisual Studio Data Generation Plan Schema Update
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTBountyClose
    1. COIt's based on the database schema of the project, not the database schema inside the database. When you create a database project, VS.NET seems to import a copy of the database schema which is then independent of the actual database. I just want to reimport this schema.
      singulars
      1. PO
      1. USbrian
    2. COOK, let me see if I understand ... You set up a DGP based on a particular DB with its schema. At this point you have a project schema that (for now) matches your DB schema. Later, you changed your DB schema, but the project schema is not updated with this. It looks like you have two issues: your project schema is now out of date, and your DGP is out of date as well. Even if you were to update (re-import) the project schema, you'd still have to update the DGP yourself from what I understand.
      singulars
      1. PO
      1. USJohn
    3. COYes, which is fine. It'd be nice if I could re-import the schema and my DGP would only need to be changed for those fields that were changed. Am I asking for too much? Is the answer to create an entirely new DGP?
      singulars
      1. PO
      1. USbrian
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload