> From: Symeon Breen > Actually updating sql tables directly from udt is pretty easy > using the BCI
I have to shake my head sometimes. Pick people are rightfully always looking for simple way to do things but when it comes to relational databases they resort to things like DTS and BCI and VSI and complex interactions that aren't necessary. Sure, I recently wrote here about a complex utility I wrote that discovers tables, views, and schema so that we can do exchanges with an RDBMS without manual mapping, but that solves a specific problem that isn't the topic of this particular thread. My policy is to not make MV do direct interaction with external environments unless I really need to do so. That policy works very well and I encourage others to consider it among other solutions. The OP question was: "Which is the simplest way to export data from Unidata to SQLServer?" When someone asks the "simplest" way to do things, consider just creating text files that have SQL queries. Then shell out to execute them or transfer them to a system where you can do so and execute them elsewhere. INSERT INTO table_name (column1, column2, column3,...) VALUES (value1, value2, value3,...) Just loop on that template in BASIC and replace the markers: INSERT INTO Employees (ID, LastName, Status) VALUES (1234, "Jones", "Terminated for stupidity") INSERT INTO Employees (ID, LastName, Status) VALUES (1235, "Smith", "Transferred to Siberia") Everyone here can understand this solution, unlike the others that have been proposed, and this is free and doesn't include any component other than BASIC. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula R&D provides Pick/MultiValue development services remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
