By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,136 Members | 1,212 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,136 IT Pros & Developers. It's quick & easy.

Deployment with database

P: n/a
All,

What's the simplest way of a deployment of an application written in C# and
using ADO.NET and MS SQL Server?

I created a deployment project in the VS2005, aded it to the solution,
configured, added the main project. The deployment project creates 2 files -
setup.exe and MyApplication.msi, it automatically checks for the existence
of MDAC and MS SQL Server 2005 Express Edition, that's fine. But to install
the application correctly I need to create a database, setup all required
permissions, then copy one DB table, which is heavy enough and should be
copied to the target DB if it's not yet created. Should I write a separate
app that can be called after I install the main application to take care of
the database? Or there is an easier way of doing that?

Also if the client machine already has a previous version of the database
and I need to upgrade it to the latest version what should I do to keep the
client's data? To analyze the database using my own application and then
upgrade the DB using some script? Or there is an easier way of doing that?

Any good ideas and/or hints will be greatly appreciated!

Thanks,
Just D.

Jan 6 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.