Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I do not know of a standard ASP.NET or SQL Server out-of-the box solution. </p> <p>One solution is to update the database object definitions outside of the ASP.NET framework. There are a few <a href="https://stackoverflow.com/questions/685053/what-is-best-tool-to-compare-two-sql-server-databases-schema-and-data">solid software options</a> that will compare the object definitions of your two databases and produce SQL code to bringer your older database in sync with your newer database.</p> <p>What will this software do? For Example, if you had this table:</p> <pre><code>Table1 (id int primary key, col_one int) </code></pre> <p>and you need to alter the table to look like this:</p> <pre><code>Table1 (id int primary key, col_one int, col_two nvarchar(50)) </code></pre> <p>then, the database compare software will either execute or print/display SQL code that looks like this:</p> <pre><code>Alter Table1 Add Column col_two </code></pre> <p>As always, be sure to create database backups before changing object definitions!</p> <p>Are you using code first? If so, (at least temporarily) disable the default database migrations. More can be found <a href="https://stackoverflow.com/a/14663178/772086">here</a> and <a href="http://msdn.microsoft.com/en-us/library/gg679461.aspx" rel="nofollow noreferrer">here</a>. This will prevent ASP.NET from dropping and re-creating your database if it finds any schema changes (I think it is better to receive an error than lose all of your data.)</p>
    singulars
    1. This table or related slice is empty.
    1. POAsp.NET, MVC4. Migrating data from a database to a new one
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USMike
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POAsp.NET, MVC4. Migrating data from a database to a new one
      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. VTAcceptedByOriginator
    1. COThank you Mike, I'm gonna try these software, hopefully without any disaster. I didn't use code first. Any suggestion about this? Anyway thank you again, cheers.
      singulars
      1. PO
      1. USAleGiovane
    2. CO@AleGiovane Because you did not use Code First, you don't need to worry about the MVC database initializer dropping your data. I think your best bet is the above - generate the database object definition differences and go from there.
      singulars
      1. PO
      1. USMike
    3. COThanks a lot again, Mike
      singulars
      1. PO
      1. USAleGiovane
 

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