SQL Server data transfer

[vinodi]

Hello all,

I am a newbie to SQL Server 2000. I have created some tables in my SQL Server installation. I wish to transfer those tables to the SQL Server located at my client's place.
We are not connected to each other over the net. How do I transfer the tables to my client's place on a CD and how do I install it over there.

Also in the future if I am make design changes in my table, how will I incorporate those tables without disturbing the data present in the tables on the client machine.

Another scenario is somewhat like this.

My client is transferring data from an Access database to SQL Server using DTS. He continues to work on the Access database for a week. Now he wants to transfer a week's data into SQL Server. How can he do that using DTS. (In a nutshell he wants to transfer only the freshly added week's data to the existing data in SQL Server- a sort of incremental backup)

Kindly provide a solution to these two scenarios.

Vinodi


~~The only place where SUCCESS comes before WORK is in the dictionary~~

 

[SiJP]

1) Find the mdf data file, copy this to the CD, then import it to your clients sql server (using Enterprise Manager)

2) When you make changes to you tables, note what changes they are.. you can then create an SQL statement that does the design changes (e.g. ALTER TABLE)

3) I've not used DTS before, but perhaps there is a way to restrict data through criteria.. an alternative is to run a make table query in access that only pulls out data for a specified week.. then use DTS to import that new table.

------------------------
Hit any User to continue