Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
joblot1976
Starting Member
10 Posts |
 Posted - 2004-09-29 : 10:18:03
|
| I have developed an application which creates financial plans for our customers. I am using SQL Server 2000 as backend, with various stored procedures. Now I want to distribute the application to the customers with their respective plans. How would I distribute the database along with the application? Should I use Access or MSDE? If I use MSDE, how would it be installed on client system, how would the tables and stored procedures be created, and how would client relative data get populated in the tables? If I choose Access, then how would my store procedures work? Please edify. Thanks |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-09-29 : 22:09:12
|
| If you've got stored procedures, you can't use Access. So MSDE is your only option. I believe you can install MSDE in quiet mode, but you'll need to consult BOL or the MS site. Once installed, you can install the database by attaching the database MDF file. This will save you from having to script the entire database. Look up attach/detach databases in BOL |
 |
|
|
joblot1976
Starting Member
10 Posts |
Posted - 2004-09-30 : 01:57:49
|
| Sorry, but what is BOL? |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-09-30 : 19:05:24
|
| SQL Server Books Online |
|
|
|
|
|
|
Distributing database with application?