Re: Any good data transfer application ?
There are a few good products. First, try LogicWorks ERWin to reverse engineer the source database, change the target server, and then forward engineer. You should be able to transfer all objects (tables, indexes, etc) that way. To transfer just tables and data, SQLServer 7.0 beta 3 has a great utility for doing that. I transferred one Oracle DB to another Oracle server without even using SQL Server. The best solution is to use ERWin to create the database, the second is to use SQLServer 7.0 to move the data. Also, you can move data by linking the tables in Access and running insert queries. There are dozens of other solutions, but that's all that come to mind. If you want, you could contract me to write a program in Visual Basic using ADO (OLE-DB) for a customized solution. I have SQLBase & SQLWindows, Informix, Oracle, SQLServer, Access, ODBC, & ADO experience. I've never used SQLAnywhere, but I'm sure I could pick it up. Let me know. Ken Brower President Innerjoin Solutions, Inc. (408) 260-0203 ---- Martin Knopp wrote in message <361243f6.3230167@news.Austria.EU.net>... >Try to get an evalutation copy of SQLBase Exchange from Centura. >Sounds to me if it could fit your needs (if one end is a SQLBase >engine). > >Martin Knopp >Pict & Byte >Austria / Europe > >On Tue, 15 Sep 1998 15:00:19 +0200, "Paolo Bormida" <bormidap@tin.it> >wrote: > >>Does anyone know of any application to tranfer a database from a >>platform/vendor to another platform/vendor using ODBC ? >> >>I mean a program to transfer from a database to another, copying just data >>or the whole metadata from eg. MS-SQL to Oracle, or Informix to >>SQL-Anywhere. >> >>Maybe a scripted driven application, with the ability to be scheduled on a >>regular basis. >> >>Thanx in advance ! >> >>Paolo >> >>---------------------------------------------- >> Paolo Bormida >> Gruppo Formula S.p.A. >> Rivoli - Torino - Italy >>---------------------------------------------- >> 011 9500500 >>---------------------------------------------- >> mailto:paolo.bormida@formula.it >>---------------------------------------------- >> >> >