|
Maybe I got misunderstood, I never suggested to
give up on DTS. However, this workaround will not work for me, as I tried to
migrate a 2000+ tables app to SAP from MS SQL and I don't intend to modify
by hand each table name..
The generation of tables went OK, I wrote a small
Java app that is generated insert statements from MS SQL in the syntax SAP
DB likes them. I could easily pass the fact that views are generated as tables.
However, I'm stuck in the fact that defining a view
( which is sintax-checked with no problems) kills the server on W2K with
'implicit server restart' ( message I don't quite understand, as the server is
not restarted, but shut down), I allready posted the view on this group, but
nobody seems to care or to have a solution. So, as you suggested, I will not
give up on DTS and MS SQL.
Thanks for your suggestions.
All best,
Dan
Be happy while you're living,
for you're a
long time dead.
----- Original Message -----
Sent: Thursday, July 24, 2003 6:41
AM
Subject: Re: Migrate data from MS sql
server 2000 to sapdb in linux
If you use the click box on the receiving column
of the DTS screen, you will be able to add the owner prefix to each of the
receiving tables. If your table names are lower case, mixed case or
other than upper case, surround them with quotation marks in the same
box. The tables and data will then go accross "auto-magically".
Just migrated 27 tables and data from Sybase to SAPdb. Worked like a
champ after those changes.
NOTE: I did not have any views
defined.
but, don't give up on Microsoft DTS without
trying if you play with it a little you should have very good
results.
John Neal
----- Original Message -----
Sent: Wednesday, July 23, 2003 6:39
AM
Subject: Re: Migrate data from MS sql
server 2000 to sapdb in linux
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="">
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
|
