Hi,
You'll need to use ALTER TABLE, ADD TABLE, DROP TABLE, etc. in a program
from the VFP side or the same in a script from the SQL2000 side. We
usually do the changes from the VFP side but we use an SQL script for
creating the database on the SQL server.
We wrote a routine that is data driven wherein each change we made is stored as a record in a free table. An example would be to add a new field to a
table in a database. Each add/modify/delete of any field/table is stored
as a field and we keep track of which version that change was made on.
The code for the changes are stored in a memo field and we use codeblck to
process them. Codeblck implements the contents of the memo field line by
line.
HTH,
Arriyel
>Hi,
>
>I'm somewhat new to SQL2000. I deployed my app from my SQL2000 to my clients site via BACKUP and RESTORE commands. That seemed to work great. I now have made a bunch of table modifications, added/changed/delete fields from my development SQL2000. When using Foxpro I've always used SDT to update my clients data structions. How can I update my clients data structures with SQL2000?
>
>
>Thanks for your help.
>
>Steve
Speak using soft and sweet words in case you have to eat them later.