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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-08 : 10:18:24
|
| Rajesh writes "I have created a project in vb6.0 & sql server 7.0.Now my question is how to deploy the sql tables & stored procedures,triggers to the client's pc.(1).Does the VB package & deployment wizard cover this aspect?(2).Can i use the DTS services to export the database first tomy laptop (using pc to pc cable) from there to the client's pc.?(3)Does the Client's pc need to have sql server installed on it?Please advice me in this regard.Thanks in anticipation of reply. Rajesh" |
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2002-02-08 : 10:26:36
|
| The database objects (triggers, procedures, etc...) will remain on the server and your client app will connect to the SQL Server. If you have written an application that will be re-sold or deployed after your initial development then you will probably have two strategies: one for installing the client piece, and another for installing the server piece (which will contain the tables and other db objects). Each user is not going to have a copy of the db objects on their local machine.Justin |
 |
|
|
|
|
|
Deploying tables/stored procedures