SQL and Vb.Net Doubt..

hi,

I want to create a Card collection program. There i have to store 4 imaes per card and many datas. Do i have to use SQL as backend? or is there any other way to do it? how to export the result in .CSV format?
Yogesh_AgarwalAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
this is plenty of questions...

>and i want to attach that db with my application
what deployment software do you use?
you must include :
§ sql express setup
§ backup of your database, or the .mdf file, or some .sql files that can create the database as needed
and depending what method you choose, your application either needs to restore from the backup, attach the db, or run the .sql statements to get the database up and running.

you need to put some thought onto the fact that the end-user might want to reinstall or upgrade later without loosing it's database/data


0
 
Yogesh_AgarwalAuthor Commented:
if i used sql as backend, how can i distribut the application? do my users need sql server to run?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
> Do i have to use SQL as backend?
you are not forced to do that, but it's much easier for the coding.
xml might be an alternative...

> do my users need sql server to run?
unless you make a central, globally available sql database, so everybody can connect to that same db, you have indeed to make the installation of your app also install the sql engine.
note: sql express has a silten install, to be included into your application setup.

your application then needs to be able to detect if the database is there, and if not, create it etc...
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Yogesh_AgarwalAuthor Commented:
its a desktop application and i want to distribut that database along with my application.. i want to write some stored procedures and attach that database.. can u please guide me to how to do it? it shud be able to connect locally(in that system). and i want to attach that db with my application, and want to run the application.. i want to export and import database too. how to do it?
0
 
Yogesh_AgarwalAuthor Commented:
>>> what deployment software do you use?

I use Visual Studios in built setup project. I will take my database backup and attach to application.. is it ok? i heard that .Net 3.5 REdis Includes SQL engine.. is it true?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>i heard that .Net 3.5 REdis Includes SQL engine.. is it true?
I don't know, sorry. stuck with .net 2.0 here :(
0
 
Yogesh_AgarwalAuthor Commented:
good
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.