Moving data from MS SQL Server 2000 or MS Access XP to UniData 5.2.9

Moving data from MS SQL Server 2000 or MS Access XP to UniData 5.2.9

Post by rnort » Sat, 31 Jan 2004 08:23:43


Complete MVDBMS neophyte -I may not even qualify at the neophyte
level- that needs a simple solution to move data -in batch
initially...real-time eventually- from RDBMSs such as SQL Server 2000
or Access 2002 (XP) to UniData 5.2.9.

Any leads would be greatly appreciated.

--Ryan N.
 
 
 

Moving data from MS SQL Server 2000 or MS Access XP to UniData 5.2.9

Post by (Latimerp » Sat, 31 Jan 2004 09:36:16


Accuterm, look at the Excel option, and then the
scripting to move it on.

www.asent.com

Better yet, most likely you need a consultant. Check
out Tony Gravagno. He's good at building interfaces,
and has most of the tools pre-built. He is at
http:(no spam)//nebula-rnd.com/ get rid of the
(no spam)

HTH, Patrick <;=)

 
 
 

Moving data from MS SQL Server 2000 or MS Access XP to UniData 5.2.9

Post by Tony Grava » Sun, 01 Feb 2004 07:01:22


Thanks for the referral Patrick. I'm not a U2 guy but I can refer
Ryan to a couple resources.

- For great info on ODBC with Unidata, get this doc:
http://www.yqcomputer.com/
- Subscribe to the U2 discussion list here. There are a lot of people
much more qualified that myself on this topic who can give you some
hands-on advice.
http://www.yqcomputer.com/

Generally, you can connect into Unidata directly via ODBC. For more
regular exchanges you might want to extract the data from SQL Server
or MS Access with a .NET Data Provider, then get into Unidata using
other tools, including free UniObjects or UniODBC, or commercial
products like RedBack or the Pick Data Provider .NET. The solution
depends on your application. Again, I'm not an expert with Unidata
connectivity, but I may be able to help whittle down your options if
you'd like to provide more info about your application.

Regards,
Tony
XXXX@XXXXX.COM
(munging a URL http:here//somedomain.com still leads to spam.)