Results 1 to 5 of 5

Thread: Copying a table.

  1. #1

    Copying a table.

    I have to do this on a Winbox using ODBC. I am using PERL and DBI. How would I go about copying a table. I'm sure this is easy but I am not seeing it. I need to convert the data from the ODBC source to a dbf formated file. I know I would use XBASE and ODBC but what would the code be like. Anyy suggestion on which functions to use?

    Any help would be much appreciated.

    Thanks
    Jamin

  2. #2

    Re:Copying a table.

    Did you ever figure it out?

  3. #3

    Re:Copying a table.

    In Oracle you can create a table based on another table... not sure which DB you're using... you can also SELECT the entire table and use Perl to build an SQL statement to create a new table and insert everything... should be pretty easy

  4. #4

    Re:Copying a table.

    You can select from table A and at the same time insert the data into table B. This can be a temp table or not. Either way. Or... bcp the data out from tab;le A then bcp the data into table B.

    What are you trying to do? Do you need the sql?
    Post some more information.

  5. #5

    Re:Copying a table.

    create table foo select * from bar;

    i don't know if that will help you or not since you're using two different databases. do you have do DBI objects or what?

Similar Threads

  1. Copying complete harddrive information
    By JTH in forum Linux - General Topics
    Replies: 2
    Last Post: 06-24-2012, 09:28 AM
  2. Copying to subdirectories
    By countach44 in forum Linux - Software, Applications & Programming
    Replies: 2
    Last Post: 11-30-2004, 11:59 PM
  3. Copying Disks with red hat
    By Omani4Ever in forum Redhat / Fedora
    Replies: 1
    Last Post: 06-10-2003, 05:40 AM
  4. DivX copying...
    By boblucci in forum General Chat
    Replies: 4
    Last Post: 05-25-2003, 11:12 PM
  5. Errors when copying files?
    By Bartman in forum Linux - Hardware, Networking & Security
    Replies: 10
    Last Post: 05-21-2003, 07:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •