Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update Wizard & Triggers
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00186454
Message ID:
00186465
Vues:
23
Unfortunately, I don't think VFP will upsize triggers. It can upsize declarative referential integrity (DRI), but DRI doesn't support cascading updates or deletes so it's of limited use. I would highly recommend a tool like xCase for managing your data model. xCase will reverse engineer your VFP database and then create a SQL Server database from the same data model. It will write SQL Server or VFP triggers to enforce RI including support for cascading. Check out www.xcase.com.

>I am trying to upsize a VFP 5 database to SQL Server. I chose the
>Wizard Option "Save Generated SQL."
>
>Everything seems to be fine, however, I cannot find the stored
>procedures that will be used as triggers!!!!!!!
>
>I found -in SCRIPTS.DBF (alias SQL_UW)- the code that will be used to
>generate tables on the server.
>
>I also find -in TABLES.DBF (alias TABLES_UW)- some fields called
>'DeleteRI', 'InsertRI', 'UpdateRI', 'DTrigName', 'ITrigName' and
>'UTrigName' but they are all *empty*
>
>Does anybody have any idea on where does the Upsize Wizard store the
>code that will be send as triggers?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform