Information générale
Forum:
Microsoft SQL Server
Titre:
Importing entire VFP Databas into SQL Server (Use DTS?)
This is a one time operation for any of our clients who are moving to SQL
Server backend from a native VFP environment.
The tables already exist in SQL7, but are empty.
For these clients, the files are large (1GB+ aggregate)
I've used the DTS 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.
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?
What is the fastest way to do this?
Or should I say there another way to do this?
Any help would be GREATLY appreciated!
Thanks in advance,
Tim
(NT4 SP6 / SQL7 SP3)
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement