I use MS BizTalk Works great and I can do real time updates to keep tables in line
And since I have worked with both Mecki and Symeon I thought I'd put my ore in Bob -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Mecki Foerthmann Sent: 21 January 2010 08:25 To: U2 Users List Subject: Re: [U2] Export files 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 ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ Confidentiality Notice: This e-mail and any attachments are intended solely for the addressee and may contain confidential or privileged information. If you are not the named addressee, or the person responsible for delivering the message to the named addressee, please notify the sender as soon as possible and delete the material from your computer. This message will be protected by copyright. If it has come to you in error, you must not take any action based on its contents nor must you copy or show the message to any person other than the intended recipient. _____________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
