Re: Which Method to Create a Database Do I Use?

Either method is acceptable. They both create a database .mdf file that can
be populated with appropriate schema. As a matter of fact, there are
probably a half-dozen ways to create a database and populate it with schema.
The fact that you're going to use it in an ASP project suggests that the SQL
Server engine be located on another system in a heavily used production
application, but for most other installations it does not make much
difference.

I discuss how to decide in depth in my book.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Jonathan Wood" <jwood@xxxxxxxxxxxxxxxx> wrote in message
news:%23iHid8uqHHA.3380@xxxxxxxxxxxxxxxxxxxxxxx
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: Need help on how to organize users and objects
    ... Yes Oracle is a bit different than Sql Server, but I think you will get the ... It doesnt become part of any schema until you assign it. ... a new developer started to work. ... need the COMMON database which stores tables with generic data and generic ...
    (microsoft.public.sqlserver.security)
  • Re: "Hidden" Replication Stored Procedures?
    ... Since the engine has hooks that hide the mssqlsystemresource database from ... 4.)Start the SQL Server service; ... Chris Jones ... aforementioned MDF file in Notepad and doing a quick search, ...
    (microsoft.public.sqlserver.replication)
  • xSQL Object 2.5.2.7
    ... synchronizing SQL Server databases. ... Server 2000 database with a SQL Server 2005 database and generate ... history of the schema changes and provide for safe and ... differences, view the scripts of objects, filter results and more; ...
    (comp.software.shareware.announce)
  • Re: Error 823
    ... Regards. ... Microsoft SQL Server Storage Engine ... > I cannot extract much data out of the database and I can't view the most ... The problem is in the .MDF file, ...
    (microsoft.public.sqlserver.tools)
  • Re: ASPNETDB.MDF when no SQLExpress, only SQL Server 2005?
    ... You will need to upload the mdf file and have your webhost attach it to the sql server. ... In which case you will need to recreate the database into the database which is available to the hosted domain if you have signed up ... The connection will be closed. ...
    (microsoft.public.dotnet.framework.aspnet)
Loading