What is the Best way for getting day wise data in production server in mysql

  • Can any one help me.............

    Please tell me what is the best way for getting data in production server.

    If possible tell me step by step with example..

    or else give the ref links for that...

    The way is ...

    I am getting the data from production server like day wise.

    and that should be stored in another server like local server.

    Please help me...........

  • Getting data into a SQL server database can take many routes.

    You could use web pages, SSIS, BCP, Bulk insert for example.

    Is the data in text files (for example)

    Can you give us any more information to help us to help you?

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • Thank u very much for u r reply..

    Once I will discuss with my manager and I will let u know...

  • Hi Good Morning.....

    With your suggestion I am trying to use another ETL tool like pentaho.

  • I can't help you out with pentaho as I don't use the product myself. Their support website is here, so they may be able to offer you more.

    If there are any more SQL server based questions please come back and ask them.

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply