Answered by:
Advice on manual data import

Question
-
Hello,I am needing to transfer data onto a Mysql database.I have had some advice and am trying to find a software solution.So main features are to be able to migrate large amounts of contacts and data every day. The migration should be done manually.Thanks a lot!Wednesday, March 24, 2010 3:40 PM
Answers
-
Hello,
What do you mean by 'manually'?
You can use some ETL tool to transfer data. In SQL Server starting from version 2005, great ETL tool is in the box - Integration Services. Basically, you create a package there, whitch describes what to do and how to do it by using different tasks connected to a workflow (for data tranfer is intended Data flow task, which in general defines where the data come from, how to transform it and where to load it). You can then exetute the package on a defined schedule, for example every day.
MP.
- Proposed as answer by Ed Price - MSFTMicrosoft employee Friday, December 21, 2012 9:07 AM
- Marked as answer by Ed Price - MSFTMicrosoft employee Saturday, December 29, 2012 7:43 AM
Wednesday, March 24, 2010 5:33 PM -
- Proposed as answer by Ed Price - MSFTMicrosoft employee Friday, December 21, 2012 9:07 AM
- Marked as answer by Ed Price - MSFTMicrosoft employee Saturday, December 29, 2012 7:43 AM
Thursday, March 25, 2010 1:56 AM -
You can also use the Import/Export wizard in the database specific tools to do this.
But again, you havent mentioned anything abt the source/target requirements for the migration/transfer of data.
As Miloslav and Louis said, you can use the SSIS ETL for this. It has lot of components to carry on this task in automatic manners.
Regards, KarthikShanth. "Mark as Answer" if this helps you!- Proposed as answer by Ed Price - MSFTMicrosoft employee Friday, December 21, 2012 9:07 AM
- Marked as answer by Ed Price - MSFTMicrosoft employee Saturday, December 29, 2012 7:43 AM
Friday, March 26, 2010 8:12 AM
All replies
-
Hello,
What do you mean by 'manually'?
You can use some ETL tool to transfer data. In SQL Server starting from version 2005, great ETL tool is in the box - Integration Services. Basically, you create a package there, whitch describes what to do and how to do it by using different tasks connected to a workflow (for data tranfer is intended Data flow task, which in general defines where the data come from, how to transform it and where to load it). You can then exetute the package on a defined schedule, for example every day.
MP.
- Proposed as answer by Ed Price - MSFTMicrosoft employee Friday, December 21, 2012 9:07 AM
- Marked as answer by Ed Price - MSFTMicrosoft employee Saturday, December 29, 2012 7:43 AM
Wednesday, March 24, 2010 5:33 PM -
- Proposed as answer by Ed Price - MSFTMicrosoft employee Friday, December 21, 2012 9:07 AM
- Marked as answer by Ed Price - MSFTMicrosoft employee Saturday, December 29, 2012 7:43 AM
Thursday, March 25, 2010 1:56 AM -
You can also use the Import/Export wizard in the database specific tools to do this.
But again, you havent mentioned anything abt the source/target requirements for the migration/transfer of data.
As Miloslav and Louis said, you can use the SSIS ETL for this. It has lot of components to carry on this task in automatic manners.
Regards, KarthikShanth. "Mark as Answer" if this helps you!- Proposed as answer by Ed Price - MSFTMicrosoft employee Friday, December 21, 2012 9:07 AM
- Marked as answer by Ed Price - MSFTMicrosoft employee Saturday, December 29, 2012 7:43 AM
Friday, March 26, 2010 8:12 AM -
A few solutions exist to migrate contacts and data you can look at. You can look into software such as Informatica or Talend Open Studio, an open source program.Friday, March 26, 2010 9:38 AM