Simple DB appliaction - DB

[Andy.I]

Hi

I'm working on a little database application, and mst be cosnidered a
newbie. What are the recomended way of making the database? Is it by adding
a database file directy in my vb solution, or making a database on my SQL
server and connecting to this?
If I choose add item from "solution explorer" and adds a SQL Server database
this way, what are the differendec with this and making it on the SQL
Server?

/A.

 

[Miro]

If you are like me - and when I started I went the Access Database
method - I would suggest - Don't.

I have switched to SQL Express. ( you will have to learn it sooner or
later anyway ).

Creating the database in the Solutions Explorer is just like doing it
through SQL Server. You will notice some terminology on some screens
will change ( seems like 2 different groups wrote them and didn't talk
to each other ) - and some items are in different positions.

As a newbie... you should get by with visual studio just fine up until
you get to security stuff ( for connecting to the database ). - I have
not gotten to this part yet.

There are some very helpful videos on Microsoft as well.
http://msdn2.microsoft.com/en-ca/vstudio/Aa700732.aspx

Hope that helps, and those are my 2 beginner cents as well.

Miro

 

[Andy.I]

I thanks for the answer.
I'm talking about SQL databases in both options. But the difference between
adding the database (sql database) in solution explorer as oposed to doing
this on the SQL serfer through management studio. Sorry if it seemed like
i'm was talking about Access.

/A.