>George,
>
>
>>>Right now, it looks like I'm going use VFP to generate the scripts I'll need and then insert them via SQL-DMO.<>
>Cool ... so you'll end up using VFP for more than generating the scripts. That works great too (using SQL-DMO). We have a little VFP utility that I wrote for doing stuff like that too.
>
Bonnie,
SQL-DMO is going to be the fun part of it. Generating the script...*sigh*...I've writing so much stuff like that, that it's pretty boring. What you can do with SQL-DMO is very cool. I'm just getting my feet wet with it. I've written some stuff in VBScript to help manage our databases. Of course, I prototyped it in VFP 7.0. Notepad's IDE leaves just a bit to be desired.< vbg >
George
Ubi caritas et amor, deus ibi est