i want to convert cvs to SQL is there any script/software

Discussion in 'MySQL' started by galpgaree2, Apr 27, 2009.

  1. #1
    hello everybody
    i have db in CVS format
    and i want to convert it to SQL format
    is there any help about that
    thx
     
    galpgaree2, Apr 27, 2009 IP
  2. chisara

    chisara Peon

    Messages:
    141
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Use an CSV import with a Postgresql or Mysql server, then do a database dump in SQL format (specify it should use insert for the dumpfile)
     
    chisara, Apr 28, 2009 IP
  3. T.Guru

    T.Guru Peon

    Messages:
    78
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Hi,

    So you want to convert your CSV files to sql?

    What I would do is use an ETL tool able to perform data integration and data migration. You will be able to transfer your files onto the sql server. There are plenty of etl programs out there. And there are open source tools.

    These might be the right thing for you as you can download them at no cost, directly on the software editor's site. Open source would allow you, if you are tech savvy, to modify your software's source code directly on your computer to adapt the program to your needs and your quests.

    Talend open studio seems like an interesting program for you. It is open source, can perform data integration, synchronization and is easy to use with its simple but thorough GUI.
     
    T.Guru, Apr 28, 2009 IP
  4. galpgaree2

    galpgaree2 Well-Known Member

    Messages:
    296
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    145
    #4
    thx alot brothers
    i try search in google but i didnt find any good one
    would u help me adding here some links to download the softwares
    thx
     
    galpgaree2, Apr 28, 2009 IP
  5. buldozerceto

    buldozerceto Active Member

    Messages:
    1,137
    Likes Received:
    43
    Best Answers:
    0
    Trophy Points:
    88
    #5
    buldozerceto, Apr 28, 2009 IP
  6. galpgaree2

    galpgaree2 Well-Known Member

    Messages:
    296
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    145
    #6
    its now work
    its saying in the page
    Please login as Administrator
    and when i click on Administrator its say
    Not Found

    The requested URL /admin/index.php was not found on this server.

    can u plz pm me with ur msn or icq
    thx and waiting for more help
     
    galpgaree2, Apr 28, 2009 IP
  7. T.Guru

    T.Guru Peon

    Messages:
    78
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Hi again,

    Here is a direct link to the Talend download page. You would need the latest version of Talend open studio.

    http://www.talend.com/download.php

    Hope this helps you!
     
    T.Guru, Apr 30, 2009 IP