Learning SQL

[Hank_Marvin]

Hi all,

Looking into learning the basics of sql.

Have a plan to make a small program with a friend who is learning vb.net, so we could both learn as we made this little project and others.

We may make a simple diary, 30days perhaps, 3 time slots in each day, prog would show db (diary days and enties in the time slots) and allow user to update the database (diary).

We would want the database to be offline and kept locally with the little program, what sql db should I use, and would be easy to setup.


Thanks

 

[Hank_Marvin]

is express the free one, along with visual studio express, etc? Yeah been going through w3schools, so wanna test out some of the basics with this test project.

so is mssql express fairly self explanitory for the type i thing i require? for what I stated above as needing.

 

[Hank_Marvin]

Right a made the database last night, and played around with it, updating, deleting, adding, pulling back data etc and all went well.

Now how do I sort of give this db to my mate?

-------------------------------------
get out of my thread you loser!

 

[Hank_Marvin]

Right click the database > Tasks > Backup

Click the add button in the bottom right and choose a location to save the backup to - make sure you add a .bak extention to the file. Hit OK.

To restore the database, reverse the process, but choose Restor instead of backup.

And say he didnt have ms sql installed? how could i give him a workable database i.e sql code attached to his vb app cud pull back/insert data from the database. so guess what i'm trying to say is can we just have his prog + my db in a folder?

Cheers

 

[Hank_Marvin]

hmmm very interesting.

so what you do if you wanted to make a phone app with visual studio phone and have a db, phone cudnt be running a sql server so would the only option be for the phone app to look out to the net for the db?

Just trying to get my head around actual ways to use the db.

 

[Hank_Marvin]

Thanks for the reply.

The phone app thing was just an example, although maybe we would try to make something later on but for now just learning basics.

We got a little diary program that we are making so we'll see how we get on with that, I think once we get one prog all hooked up to a db we'll have a better understanding for future progs.

I'll have a look into SQL Server Compact.

Thanks

 

[Hank_Marvin]

Right so I was playing around with it and I actually made a sql compact 2008 db, didnt realise but anyway, now trying to sort out a proper ms sql 2008 db, now don't know if it's because when I installed it the options were wrong etc but the only server i can get to load is the compact version.


I load up sql server manager 2008

I get two options database engine or sql compact

now I presume database engine is the normal full on sql 2008? but when I press that, it then wants details which i cant provide.

Any advice on the initial creation/setup of the server would be good.

Cheers

 

[Hank_Marvin]

i think you maybe right, i didnt change the default instance during installation, i did however put in a username password and think i picked sql server authentication.

This is error i get

"TITLE: Connect to Server
------------------------------

Cannot connect to HankMarvin-pc\SQLEXPRESS2008.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?Prod...rver&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------"

Anyway to check details, edit server without reinstalling?


Thanks

 

[Hank_Marvin]

kkbigal = total ace dude - got in the config and found out everything I needed.

hankmarvin-pc\SQLEXPRESS = server and I just put to "windows auth" and it connected so i wasnt far off before lol.

Thanks a lot buddy

 

[Hank_Marvin]

I've not used it in a long time and then only to learn the basics so that question hadn't popped up but i'll read it for sure, im sure it'll come in handy at some point.

Cheers