Databases
StackOverflow2013
Postsdbo
PORules to follow in the development stage, so it makes the deployment stage easier
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PORules to follow in the development stage, so it makes the deployment stage easier
    primarykey
    data
    text
    <p>What's your advice/points for developers to follow or avoid in the development and early stages of developing a database driven asp.net websites. so we could have an easy and efficient deployment -specially in development(creating) the database to be easily deployed in the feature on my shared hosting server- .</p> <p><strong>Edit 1</strong></p> <p>I'm sorry, but still I didn't get any detailed advice specially about the database. I mean, I'm creating my website database using the SqlExpress -am not sure which version. this is from the connection string "AttachDbFilename="C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\DB.mdf"- . I use the Database Diagrams option in the studio to create FKs and create the relations between table.</p> <p>So how can I copy this database structure and data in the future to be used on a server. I was thinking maybe I should do it all in SQL and save the script and run it later on a database that I'd create on the deployment server.</p> <p>Just some thoughts! I hope I'd find some great ways to do it from developers who already deployed websites before!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USlKashef
    1. USlKashef
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PORules to follow in the development stage, so it makes the deployment stage easier
      1. This table or related slice is empty.
      1. VTModeratorReview
    1. COSQL Server or MS Access or MySQL?
      singulars
      1. PORules to follow in the development stage, so it makes the deployment stage easier
      1. USDavide Piras
    2. CO@ Davide Piras- SQL Server
      singulars
      1. PORules to follow in the development stage, so it makes the deployment stage easier
      1. USlKashef
 

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