Databases
StackOverflow2013
Postsdbo
POVisual studio 2010 sql project - how to run?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POVisual studio 2010 sql project - how to run?
    primarykey
    data
    text
    <p>I have a SQL project in my .Net project in Visual Studio 2010. I added it to my solution because I thought it will help me to create all the database objects in more environment without difficulties. My scope is to create/define the database objects (tables and stored procedures) in more computers, easily.For this purpose I created an Sql project in visual studio and I added for each table and stored procedure the creation script in this project. Now I have 30 scripts and I'd like to run it on a new sql instance. </p> <p>If I open each sql file I have, in visual studio, an toolbat that allows me to tun the opened file on a sql instance (I have an connect button) and this generates the proper object (table or SP).</p> <p>The question is: how do I do to run all the files in this project in one click. How to create all the objects in one click? Now I have about 30 scripts to run, and I need a proper way.</p> <p>The way I tried to do it was to set as default project the sql project and to press run (F5), but then I got some strange compilation errors in sql files, errors witch didn't was there when I run (execute) each script individually. </p> <p>Here is the right click menu for this project (No Run, Publish or something else!): <img src="https://i.stack.imgur.com/74RMV.png" alt="enter image description here"></p> <p>I tried to use from that menu the Deploy command. The bad news (for me) is that I got this on that command: <img src="https://i.stack.imgur.com/SEaJF.png" alt="enter image description here"></p> <p>I don't have any error in my sql scripts, each one runs correctly.</p> <p>Thank you.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USZelter Ady
    1. USZelter Ady
    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. This table or related slice is empty.
    1. COIf you have a SQL Server Database Project (SSDT), you can right click on the project and select publish.
      singulars
      1. POVisual studio 2010 sql project - how to run?
      1. USCandiedCode
    2. COI don't have a publish command in right click menu. How do I know what kind of project do I have?
      singulars
      1. POVisual studio 2010 sql project - how to run?
      1. USZelter Ady
    3. COSSDT are the newest database projects. If you are using VS 2010, you need to install sp1. I believe the Deploy is what you are looking for. Select that option and see if it works. (Its been a while since I used that project, so I don't remember off the top of my head).
      singulars
      1. POVisual studio 2010 sql project - how to run?
      1. USCandiedCode
 

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