Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

What is the Best way for getting day wise data in production server in mysql Expand / Collapse
Author
Message
Posted Wednesday, January 23, 2013 8:50 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, April 07, 2014 7:08 AM
Points: 84, Visits: 103
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
Posted Wednesday, January 23, 2013 9:00 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 8:59 AM
Points: 2,824, Visits: 2,834
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
Posted Wednesday, January 23, 2013 9:07 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, April 07, 2014 7:08 AM
Points: 84, Visits: 103
Thank u very much for u r reply..

Once I will discuss with my manager and I will let u know...
Post #1410661
Posted Wednesday, January 23, 2013 10:05 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, April 07, 2014 7:08 AM
Points: 84, Visits: 103
Hi Good Morning.....

With your suggestion I am trying to use another ETL tool like pentaho.
Post #1410888
Posted Thursday, January 24, 2013 1:14 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 8:59 AM
Points: 2,824, Visits: 2,834
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 »

Add to briefcase

Permissions Expand / Collapse