Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Extracting things from SQL Server
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00759133
Message ID:
00760874
Views:
35
>>>The idea that I've been toying was to put together something like the VS.NET's "Server Explorer" for using within VFP. I've always thought that that would be really useful. Let's put that together?? :)
>
>>I don't know that it be very practical. The main requirement is that SQLDMO be installed.
>
>hmmm... I see your point... yeah, it may doesn't worth the effort....

I'm not sure, but my guess would be that VS.NET may install it in order to display the Server Explorer. Again, just a guess.

The real utility comes when you're faced with a repetitive task. What I did was pretty simple: Created a table with the groups, created one with the databases, and another for the tables. Also created relationships be the groups, databases, and tables. It allows me to specify what databases, and tables to run a script against.

The tables where created using SQLDMO and Fox. As I said, I'd be happy to share the general information regarding how this is done.


>>Sorry I didn't bring the guitar.< s > Guitars and airplanes don't go together well.
>
>Yes, that was really missed. I'd really have enjoyed. :)

I'm not so sure you would've after you heard me play.:-)
George

Ubi caritas et amor, deus ibi est
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform