Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #842

Re: What is the difference between create a db in server explorer to create in solution explorer

Show all headers | View raw

Tony (johansson.andersson@telia.com) writes:
> I can create a database in solution explorer in the following way.
> 1. Right click the project choose add new item
> 2. Choose a SQL Server Database
> 3 You get a question if you want to add the database to App_Data
> 
> When you have done this the database will also appear in the Server
> Explorer with extension mdf The created database does not exist within
> the list of available databases in sql server Management Studio 
> 
> I can also create a database from server Explorer in the following.
> 1.Right click on the Data Connection and choose Create new SQL server 
> Database
> 2.A dialog (Create New SQL Server Database) appear.
> 3. Choose what server for example the default server instance or perhaps
> the named express instance 
> 4.Give the database a name.
> 5 Now the database appear in the Server explorer with extension dbo
> The created database also appear within the list of available databases in 
> sql server Management
> 
> Now to my question what is the difference between these two ways to
> create a database ? 

What are these Explorers you are talking about? That sounds like Visual
Studio to me.

I think VS creates a database and then detaches it, and leaves you 
with the file, and you are supposed to use the option AttachDBFilename.
Now, why on Earth you would do this, I have absolutely no idea. But 
then generally Visual Studio leaves me in a maze. You may have to ask
in a Visual Studio forum for a better answer.

In *SQL Server* you can only create a new database in a single way: the 
CREATE DATABASE statement. And the tools always connect to SQL Server 
to run statements.

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

What is the difference between create a db in server explorer to create in solution explorer "Tony" <johansson.andersson@telia.com> - 2011-11-24 12:26 +0100
  Re: What is the difference between create a db in server explorer to create in solution explorer Erland Sommarskog <esquel@sommarskog.se> - 2011-11-24 23:40 +0100

csiph-web