Which Method to Create a Database Do I Use?



It appears there are two methods for creating a database as part of an ASP project.

I can use the Server Explorer and create a database that I can't easily see as a file, and create a connection. On the other hand, I can right click in the Solution Explorer window and select Add New Item, and then create an SQL Database. This creates an MDF file directly.

I'm having trouble getting up to speed on the database stuff and have two seemingly unrelated ways to create my database makes it all the more confusing.

Can anyone explain the difference between these two methods, and then help me understand which is the best method for creating a database to be used by my Web page?

Thanks!

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com

.



Relevant Pages

  • RE: Server Explorer failling to log in to (local) DB
    ... Server Explorer shouldn't be persisting data about what database it was last connected to. ... When ever I try to expand the MSDE Node on the local machine ... Maybe I am missing something so if you could provide more detail about how you are navigating to MSDE via SE that would be ...
    (microsoft.public.vsnet.enterprise.tools)
  • Re: Creating SQL Server Databases With No Security Restrictions
    ... > execute it from Query Analyzer. ... The database itself is OK, as I can access it in Enterprise Manager. ... database files that I am able to access in Server Explorer. ...
    (microsoft.public.sqlserver.msde)
  • Re: Creating SQL Server Databases With No Security Restrictions
    ... > execute it from Query Analyzer. ... The database itself is OK, as I can access it in Enterprise Manager. ... database files that I am able to access in Server Explorer. ...
    (microsoft.public.sqlserver.security)
  • Re: The Microsoft jet engine cannot find the input table or query
    ... I viewed the database and table in server explorer, ... I commented out the table mappings and gave it another run. ... Dim myOleDbConnection As OleDbConnection ...
    (microsoft.public.dotnet.framework.adonet)
  • Server Explorer problem
    ... I'm just getting up to speed learning SQL. ... I created database in server explorer and added some tables and columns. ... Dim Con As SqlConnection ...
    (microsoft.public.vstudio.development)