Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need to compare DBC's
Message
From
29/08/2002 12:29:32
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00694318
Message ID:
00695021
Views:
16
Doug,

Thanks for the idea. I have considered something like that, but have not yet tried it. For my purposes right now it is most important to be able to compare view definitions (the other objects are important but not as much so), and then automate the process of 'synching them up', if they are different. Erik Moore has a utility called genview, which generates just a view definition. I am considering modifying genview such that instead of just writing the view definition statements to a file, it will write them to a metadata table (besides the dbc) which will store one row of data per view property, for two views, view1 and view2, which are to be compared, (not sure how to handle field level properties), and then compare the values, and
report on the differences and provide for the ability to synchronize them, in either 'direction', via some grid interface that shows the properties side by side.




>David,
>
>Have you tried running GenDbc.prg for both of the DBCs then running WinDiff or some other comparison utility against the resultant PRGs?
>
>Doug
>
>>I am hoping to find a utility that will allow me to compare two DBC's. For my purposes in particular, the DBC's only contain views (remote views) and they are in the same folder - this is a constraint of the application I am working with - Visual Accountmate.
>>
>>I looked at some other posts and some of the downloads in the downloads section. So far I have found:
>>
>>1) DataDelta/Foxyclasses
>>(Still checking it out, but I'm not sure whether this will handle views, and don't think it will handle the case where they are in the same directory)
>>
>>2)Utility by Chad Lemmer - compares dbc's - but it only looks at tables, not views
>>
>>Any suggestions would be appreciated.
Previous
Reply
Map
View

Click here to load this message in the networking platform