Creating a local SQL Database

[TwoSugars]

Hi people,
I am new to SQL and was wondering if its possible to create a local SQL Server (i.e. not on a server but just saved on the HDD). If so, what package can this be done in? I have Visual Studio.NET but I cant seem to do it in this. Thanks for any help.

-TS

 

[f0xy]

You looked at the express edition of mssql server from microsoft? its free i think...

EDIT: http://www.microsoft.com/sql/editions/express/default.mspx

 

[TwoSugars]

I've not looked at it but I do know it exists! Can it be done in this?

 

[f0xy]

im not too sure what your exactly after lol... erm are you wanting a facility to allow you to use sql databases in your vb.net applications?

 

[Munday]

You could use an MSDE database but it has a 2Gb limit.

 

[f0xy]

You could use an MSDE database but it has a 2Gb limit.

thats probably a better idea acctually

 

[TwoSugars]

Ok ppl, sorry for the confusion. I'm after creating a an SQL Database. However, when I hear the words SQL they are always followed by Server. I just want to create an SQL database like I would if I was using MS Access. Hope that makes more sense?

 

[f0xy]

Ok ppl, sorry for the confusion. I'm after creating a an SQL Database. However, when I hear the words SQL they are always followed by Server. I just want to create an SQL database like I would if I was using MS Access. Hope that makes more sense?

probably best using what Munday said then.

 

[TwoSugars]

Well, I'm all confused..lol
Can I create an SQL Database like I would if I was using MS Access. I.e. just open a program, create the database and then save it to a file?

 

[f0xy]

this might sound stupid... but why dont you use access? im sure you can acctually create an access database through visual studio...

 

[TwoSugars]

Access is ruled out for various reasons. I'll install SQL Express and have a go now

 

[Munday]

You can make MS Access read from an MSDE database but you may need to have an ODBC data source.
MSDE doesn't come with any of the data tools (like Enterprise manager, query analyser, profiler etc) but you can still get them to work with it.

 

[TwoSugars]

Sorry for my lack of knowledge but I am lost here. All I wanted was a program that would make an SQL Database and output a database file. For example, MS Access lets you create a database, save it to your HDD. I'm guess from the complexity of the answers that there is no such program.

 

[Harry_manback]

http://www.cliosport.net/forum/showthread.php?p=2131810#post2131810


sorry to crash but i need help

 

[Munday]

Sorry for my lack of knowledge but I am lost here. All I wanted was a program that would make an SQL Database and output a database file. For example, MS Access lets you create a database, save it to your HDD. I'm guess from the complexity of the answers that there is no such program.

If you had MSDE installed and Enterprise Manager then you can manually create an SQL database.
Not sure how you would do it any other way sorry

 

[f0xy]

http://www.cliosport.net/forum/showthread.php?p=2131810#post2131810


sorry to crash but i need help

added you to msn mate.

 

[TwoSugars]

Sorry for my lack of knowledge but I am lost here. All I wanted was a program that would make an SQL Database and output a database file. For example, MS Access lets you create a database, save it to your HDD. I'm guess from the complexity of the answers that there is no such program.

If you had MSDE installed and Enterprise Manager then you can manually create an SQL database.
Not sure how you would do it any other way sorry

Would this then allow me to save the SQL Database as a .mdf file?

 

[Munday]

If you had MSDE installed and Enterprise Manager then you can manually create an SQL database.
Not sure how you would do it any other way sorry

Would this then allow me to save the SQL Database as a .mdf file?

Yes, you will get a .mdf and also a .ldf file (log file).

 

[TwoSugars]

Thanks for the help people, I have now created an SQL Database (.mdf).
However, I now have a new problem..lol. I can link a VB.NET app to the new database but when I add a new record, it doesnt seem to save. Any ideas?

-TS