Is there a way to create a database using SQL Server Express 2008. What I would like to do is create tables and columns, and to populate the database. Most database programs like Access have an interface to do this.
Printable View
Is there a way to create a database using SQL Server Express 2008. What I would like to do is create tables and columns, and to populate the database. Most database programs like Access have an interface to do this.
Hey,
Assuming that you are using the Express editions of Visual Studio, it is not possible to create a database from within the IDE. If you have the full version of Visual Studio, then you should be able to create a database from within the solution explorer.
Either way, you can also download the SQL Server Management Studio Express from here.
This is bascially a stripped down version of the Enterprise Manager which is available for a full SQL Server Instance.
You can use it to create databases, tables, columns etc, as well as apply any necessary security to the database.
Once the database is created, you can then connect to the database from within Visual Studio, and within the IDE you can then also create tables,columns etc.
Hope this helps!!
Gary
Actually, if you have SQL Express installed, you CAN open the Server Explorer in VS (the IDE), right-click on Data Connections and add a new SQL Express DB right there....
Of course you can also use this method to create a DB on a SQL server on your network - Local or remote.... Anywhere -
Management Studio is a good idea to have - for sure - especially if you manage multiple DB and are not developing DB all the time....
But for DB creation, Visual Studio has everything you need