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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » Anything that is NOT about SQL! » What is the Best way for getting day wise...

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

Rate Topic

Display Mode

Topic Options

Author

Message

kalivaraprasadm

Posted Wednesday, January 23, 2013 8:50 AM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 12:10 AM
Points: 81, Visits: 95

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...........

Post #1410639

Stuart Davies

Posted Wednesday, January 23, 2013 9:00 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 2:28 AM
Points: 2,474, Visits: 2,132

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
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

Post #1410652

kalivaraprasadm

Posted Wednesday, January 23, 2013 9:07 AM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 12:10 AM
Points: 81, Visits: 95

Thank u very much for u r reply..

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

Post #1410661

kalivaraprasadm

Posted Wednesday, January 23, 2013 10:05 PM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 12:10 AM
Points: 81, Visits: 95

Hi Good Morning.....

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

Post #1410888

Stuart Davies

Posted Thursday, January 24, 2013 1:14 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 2:28 AM
Points: 2,474, Visits: 2,132

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
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

Post #1410971

« Prev Topic | Next Topic »

Permissions