OpenEdge101B -> SQL 2005

Yahoo Archive
1
We setup a linked server on our 2005 box, and run a query similar to the
one below to populate the data using scheduled jobs. If there is a
better way, we sure would be interested too.



Select
PartNum,ProdCode,CheckBox01,PartDescription,UPCCode1,ClassID,TypeCode,Pr
icePerCode,RunOut,InActive,CheckBox02,CheckBox03,CheckBox04,CheckBox05,C
heckBox06,CheckBox07,ShortChar01,ShortChar02,ShortChar03,UnitPrice,NetWe
ight,NetVolume,PartLength,PartWidth,PartHeight

INTO #TmpE

From openquery(VANTAGE_LIVE, 'Select
PartNum,ProdCode,CheckBox01,PartDescription,UPCCode1,ClassID,TypeCode,Pr
icePerCode,RunOut,InActive,CheckBox02,CheckBox03,CheckBox04,CheckBox05,C
heckBox06,CheckBox07,ShortChar01,ShortChar02,ShortChar03,UnitPrice,NetWe
ight,NetVolume,PartLength,PartWidth,PartHeight From PUB.Part ')



BEGIN TRANSACTION



DELETE VantageSQL.dbo.[Part]



INSERT VantageSQL.dbo.[Part]

(PartNum,ProdCode,CheckBox01,PartDescription,UPCCode1,ClassID,TypeCode,P
ricePerCode,RunOut,InActive,CheckBox02,CheckBox03,CheckBox04,CheckBox05,
CheckBox06,CheckBox07,ShortChar01,ShortChar02,ShortChar03,UnitPrice,NetW
eight,NetVolume,PartLength,PartWidth,PartHeight)

SELECT
PartNum,ProdCode,CheckBox01,PartDescription,UPCCode1,ClassID,TypeCode,Pr
icePerCode,RunOut,InActive,CheckBox02,CheckBox03,CheckBox04,CheckBox05,C
heckBox06,CheckBox07,ShortChar01,ShortChar02,ShortChar03,UnitPrice,NetWe
ight,NetVolume,PartLength,PartWidth,PartHeight

FROM #TmpE



COMMIT TRANSACTION



Drop Table #TmpE



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bartosz Niemczewski
Sent: Friday, October 09, 2009 10:40 AM
To: Vantage Group
Subject: [Vantage] OpenEdge101B -> SQL 2005





Hello,
I am looking for instructions how to move data from OpenEdge101B to SQL
2005. We are in Vantage 803.407A. Any help will be appreciated.

Thank you.

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
2
Hello,
I am looking for instructions how to move data from OpenEdge101B to SQL 2005. We are in Vantage 803.407A. Any help will be appreciated.

Thank you.





[Non-text portions of this message have been removed]