RE: Move SQL Server Tables to Oracle
Yeah, that's what I thought, though I'm not familiar with UPI. Sorry, question was kind of tongue in cheek -:) Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Tanel Poder Sent: Thursday, September 18, 2003 6:20 PM To: Multiple recipients of list ORACLE-L No it doesn't, sqlldr probably uses OCI... or in some cases maybe even lower-level layer, UPI (user program interface). Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 19, 2003 1:19 AM Ken, Could you please elaborate on how SQL*Loader uses SQL*Plus? Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- KENNETH JANUSZ Sent: Thursday, September 18, 2003 3:40 PM To: Multiple recipients of list ORACLE-L That will work as long as they are sets of tables are the same layout. If not, then you have to map from SQL Server to Oracle which could be a complex time consuming task. Then the best bet is to generate delimited flat files from SQL Server and use SQL*Loader to load them into Oracle. For this I recommend the book: SQL*Loader, The definitive Guide by Gennick Mishra. Sorry to say it SQL*Loader uses SQL*Plus, not Perl. My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 2:59 PM If you are familiar with Perl and DBI, you can pre-create the tables in Oracle, open a connection to both the MS and Oracle databases, select from MS, insert to Oracle. Do it all in one step, it's pretty straightforward. Jared On Thu, 2003-09-18 at 00:59, Gunnar Berglund wrote: Hi all, I need to move some sql server tables to oracle. Do you have some ideas how to do it. I have no idea ... rgds G - Want to chat instantly with your online friends? Get the FREE Yahoo!Messenger -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list,
Re: Move SQL Server Tables to Oracle
Hi Gunner You can push data from the sql server via DTS (Data transformation services) or pull the data from the Oracale database via (Heterogeneous services) Gunnar Berglund wrote: Hi all, I need to move some sql server tables to oracle. Do you have some ideas how to do it. I have no idea ... rgds G Want to chat instantly with your online friends? *Get the FREE Yahoo! Messenger* http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.com/ -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 smime.p7s Description: S/MIME cryptographic signature
RE: Move SQL Server Tables to Oracle
You can always use the SQL Server DTS package to do this. Dave -Original Message-From: Gunnar Berglund [mailto:[EMAIL PROTECTED]Sent: Thursday, September 18, 2003 3:00 AMTo: Multiple recipients of list ORACLE-LSubject: Move SQL Server Tables to Oracle Hi all, I need to move some sql server tables to oracle. Do you have some ideas how to do it. I have no idea ... rgds G Want to chat instantly with your online friends?Get the FREE Yahoo! Messenger
Re: Move SQL Server Tables to Oracle
If you are familiar with Perl and DBI, you can pre-create the tables in Oracle, open a connection to both the MS and Oracle databases, select from MS, insert to Oracle. Do it all in one step, it's pretty straightforward. Jared On Thu, 2003-09-18 at 00:59, Gunnar Berglund wrote: Hi all, I need to move some sql server tables to oracle. Do you have some ideas how to do it. I have no idea ... rgds G - Want to chat instantly with your online friends? Get the FREE Yahoo!Messenger -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Move SQL Server Tables to Oracle
That will work as long as they are sets of tables are the same layout. If not, then you have to map from SQL Server to Oracle which could be a complex time consuming task. Then the best bet is to generate delimited flat files from SQL Server and use SQL*Loader to load them into Oracle. For this I recommend the book: SQL*Loader, The definitive Guide by Gennick Mishra. Sorry to say it SQL*Loader uses SQL*Plus, not Perl. My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 2:59 PM If you are familiar with Perl and DBI, you can pre-create the tables in Oracle, open a connection to both the MS and Oracle databases, select from MS, insert to Oracle. Do it all in one step, it's pretty straightforward. Jared On Thu, 2003-09-18 at 00:59, Gunnar Berglund wrote: Hi all, I need to move some sql server tables to oracle. Do you have some ideas how to do it. I have no idea ... rgds G - Want to chat instantly with your online friends? Get the FREE Yahoo!Messenger -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Move SQL Server Tables to Oracle
The rather terse initial post says move some sql server tables to oracle. No mention of changing design. On Thu, 2003-09-18 at 13:39, KENNETH JANUSZ wrote: That will work as long as they are sets of tables are the same layout. If not, then you have to map from SQL Server to Oracle which could be a complex time consuming task. Then the best bet is to generate delimited flat files from SQL Server and use SQL*Loader to load them into Oracle. For this I recommend the book: SQL*Loader, The definitive Guide by Gennick Mishra. Sorry to say it SQL*Loader uses SQL*Plus, not Perl. My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 2:59 PM If you are familiar with Perl and DBI, you can pre-create the tables in Oracle, open a connection to both the MS and Oracle databases, select from MS, insert to Oracle. Do it all in one step, it's pretty straightforward. Jared On Thu, 2003-09-18 at 00:59, Gunnar Berglund wrote: Hi all, I need to move some sql server tables to oracle. Do you have some ideas how to do it. I have no idea ... rgds G - Want to chat instantly with your online friends? Get the FREE Yahoo!Messenger -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Move SQL Server Tables to Oracle
You can try to create Oracle linked server in sql server and you should be able insert from SQL Server to Oracle. I used this approach to get data from DB2 to SQL Server. -Original Message-From: Gunnar Berglund [mailto:[EMAIL PROTECTED]Sent: Thursday, September 18, 2003 1:00 AMTo: Multiple recipients of list ORACLE-LSubject: Move SQL Server Tables to Oracle Hi all, I need to move some sql server tables to oracle. Do you have some ideas how to do it. I have no idea ... rgds G Want to chat instantly with your online friends?Get the FREE Yahoo! MessengerDISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
RE: Move SQL Server Tables to Oracle
Ken, Could you please elaborate on how SQL*Loader uses SQL*Plus? Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- KENNETH JANUSZ Sent: Thursday, September 18, 2003 3:40 PM To: Multiple recipients of list ORACLE-L That will work as long as they are sets of tables are the same layout. If not, then you have to map from SQL Server to Oracle which could be a complex time consuming task. Then the best bet is to generate delimited flat files from SQL Server and use SQL*Loader to load them into Oracle. For this I recommend the book: SQL*Loader, The definitive Guide by Gennick Mishra. Sorry to say it SQL*Loader uses SQL*Plus, not Perl. My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 2:59 PM If you are familiar with Perl and DBI, you can pre-create the tables in Oracle, open a connection to both the MS and Oracle databases, select from MS, insert to Oracle. Do it all in one step, it's pretty straightforward. Jared On Thu, 2003-09-18 at 00:59, Gunnar Berglund wrote: Hi all, I need to move some sql server tables to oracle. Do you have some ideas how to do it. I have no idea ... rgds G - Want to chat instantly with your online friends? Get the FREE Yahoo!Messenger -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Move SQL Server Tables to Oracle
No it doesn't, sqlldr probably uses OCI... or in some cases maybe even lower-level layer, UPI (user program interface). Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 19, 2003 1:19 AM Ken, Could you please elaborate on how SQL*Loader uses SQL*Plus? Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- KENNETH JANUSZ Sent: Thursday, September 18, 2003 3:40 PM To: Multiple recipients of list ORACLE-L That will work as long as they are sets of tables are the same layout. If not, then you have to map from SQL Server to Oracle which could be a complex time consuming task. Then the best bet is to generate delimited flat files from SQL Server and use SQL*Loader to load them into Oracle. For this I recommend the book: SQL*Loader, The definitive Guide by Gennick Mishra. Sorry to say it SQL*Loader uses SQL*Plus, not Perl. My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 2:59 PM If you are familiar with Perl and DBI, you can pre-create the tables in Oracle, open a connection to both the MS and Oracle databases, select from MS, insert to Oracle. Do it all in one step, it's pretty straightforward. Jared On Thu, 2003-09-18 at 00:59, Gunnar Berglund wrote: Hi all, I need to move some sql server tables to oracle. Do you have some ideas how to do it. I have no idea ... rgds G - Want to chat instantly with your online friends? Get the FREE Yahoo!Messenger -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Move SQL Server Tables to Oracle
Look into Oracle's Migration Workbench utility. It's a free download from OTN. It can move tables, table data, indexes, constraints, etc. Also converts data types if needed. I've used it to move Acess databases to Oracle and it works pretty well. I believe they have a SQL Server module as well. Dave -Original Message-From: Gunnar Berglund [mailto:[EMAIL PROTECTED]Sent: Thursday, September 18, 2003 3:00 AMTo: Multiple recipients of list ORACLE-LSubject: Move SQL Server Tables to Oracle Hi all, I need to move some sql server tables to oracle. Do you have some ideas how to do it. I have no idea ... rgds G Want to chat instantly with your online friends?Get the FREE Yahoo! Messenger