how's it going all, i must Deploy my home windows application written with c# (Express edition 2010) and SQL server express edition 2008 and i wish to understand how to perform the following:
1- The steps to deploy the applying and just how to create all configurations(i believe with express edition there's just one way click once method, but exactly how set the configurations for this?
2- after Deploy my application what i must do in order to setup or do the installation within the customer machine(needs for software side) to really make it work?
3- What's the best place to place my database files(MDF and LOg) within the customer machine c: or D: and just how to avoid anyone to gain access to the database without needing Application since the connection string is much like that:
"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\FamilyHistory.mdf;Integrated Security=True;User Instance=True"
4- Finally i wish to understand how to make backup for that database every so often , can there be any automatic method to achieve that or i must make manualy by copy it make up the customer machine.
Sorry for lengthy publish or even the many Questions however , i want anyone that helped me to As soon as possible and i'll appreciate if anyone response even when he come with an answer for just one Question :).
Thanks ahead of time
You are able to take a look at numerous deployment techniques. You should use click once however i strongly advise using something similar to NSIS(free). Use a software HM NIS Edit(also free) that does the effort for any .internet project. Try the fit your personal machine and you will understand how to deploy. By client i'm guessing you mean your customer instead of client/server type client?
the response to three in my opinion (although i rarely perform the old file discussing nowadays) that you ought to put the file within the temp folder in home windows, however, i'm prepared to be wrong about this.
It is dependent on which data provider you're using however, you just produce a sqlcommand object(as i am sure you are aware how) then type in the backup sql something similar to:
BACKUP DATABASE AdventureWorks2008R2 TO DISK = 'Z:\SQLServerBackups\AdvWorksData.bak' WITH FORMAT; GO
hopefully has assisted.