Unfortunately, that doesn't works, at least with SQL Server 2000 and SAP
7.4.3.25 on same machine and on Redhat 8.0 machine. Tables are created,
views are created as tables, and tables are not populated, probably because
MS SQL DTS doesn't use the user name to fully qualify a table, as SAP DB
requests ( just a guess, didn't had time to do a SQL trace on ODBC driver )
All best,
Dan
Be happy while you're living,
for you're a long time dead.
----- Original Message -----
From: "Dittmar, Daniel" <[EMAIL PROTECTED]>
To: "'poornima ponnuswamy'" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, July 23, 2003 12:58 PM
Subject: RE: Migrate data from MS sql server 2000 to sapdb in linux
> > 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/re
plhet_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
>
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
