HOWTO: Deploy a VB6/SQL Server 7 app

[GerryWhite]

Creating and deploying a VB app is pretty straightforward. However, I can't seem to find docs which describe the steps necessary in order to take my SQL Server 7 tables from my local system and put them on my client's. Any suggestions on where I can read up on this?
Thanks!
- Gerry


------------------
** Gerry White
** BCS Engineering
** Ramona, CA, USA

[Clunietp]

why do you want to take the tables from SQL server and put them on your client? If you just mean you want to access SQL server from your client, then you have to distribute the data access components (assuming you use ado). If you want to physically move the tables and data to a new database (such as access), then you can use the Data Transformation Services (DTS) to export the data.

plz be more specific

thx

Tom

[GerryWhite]

Basically, I'm interested in transporting the existing SQL Server tables for this application to the customer's site.

This is an app which uses VB as the front-end and SQL Server for database engine.

[This message has been edited by GerryWhite (edited 10-16-1999).]

[Clunietp]

Export the SQL data using the DTS to an access database.

Bring the Access DB to your customers site.

Import the data using DTS once again.

All Done!

HTH

Tom