Another novice here . . .
(NT4 SP6 / SQL7 SP3)
This is a one time operation for any of our clients who are moving to SQL
Server from VFP. The tables already exist in SQL7, but are empty.
Needless to say, the files are large (1GB+ aggregate)
I've used the wizard to at least create a DTS package. But then I have to go
into each work flow diagram and select the table lock option so that the
package does not create any transaction logs . . . there are 100+ tables.
What is the fastest way to do this?
Also, over time, the structures of both databases will change.
The structure of some of the SQL tables differ from those in VFP (mostly
that a identity field has been added) So I would have to continually
recreate this huge package every time there is a structure update.
Is there a way I can create a package programmatically?
Is there another way to do this?
Any help would be GREATLY appreciated!
Thanks in advance,