Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Database Optimization...
Message
From
01/06/2006 13:46:20
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Database Optimization...
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01126546
Message ID:
01126546
Views:
72
I have a non relational SQL database, this one has been created by a tool named "Wizard Upsizing" in Visual Foxpro. My apps are coded in Visual Foxpro and I don't want to modify them. I would like to make my SQL database relational (added fields, tables, etc). Is it possible to reorganize dynamically (in sync) the data in the new database structure, without changing on client side. By example, I wonder if using of trigger to replicate changes between old & new structure could be possible and acceptable (at level of performance, etc)?
Marc Levesque
La Prairie, Quebec (CANADA)
marc.levesque@videotron.ca
Next
Reply
Map
View

Click here to load this message in the networking platform