Tony, I think it is a lot simpler to just go into SQL Server and run the Import Export Wizard than writing a Basic program for every export. And BTW DTS and SSIS are integral part of SQL Server and don't cost a penny extra. So if you have the tools already, why not use them?
I transfer the data of 30 odd UD files to SQL Server every night and one file gets written every hour. And I don't have to lift a finger and didn't have to write a single line of code in Basic. Now that's what I call simple! Mecki Tony Gravagno wrote: >> 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 > > _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
