> I have a database in MS SQL Server 2000 and it has > around 40 tables and around 800,000 rows in each > table. I have SAPDB installed in Red hat linux. What > is the best way to migrate all the data from sql > server to sapdb. Any help or advice will be > appreciated
MS SQL Server seems to contain a service to copy table definitions and data between ODBC databases. You'll have to install the SAP DB ODBC driver on your Windows machine, define a data source for your Linux database, start the process and knock on wood. see <http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replhet_7feb.asp> for details. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
