locked
Advice on manual data import RRS feed

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

    Wednesday, March 24, 2010 5:33 PM
  • If you mean a MySQL database as opposed to SQL Server, then you probably need to find find a different set of forums.  These are for SQL Server, the product made by Microsoft. SQL Server has a tool called SSIS, but you will need a license to SQL Server to use it.


    Louis

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

    Wednesday, March 24, 2010 5:33 PM
  • If you mean a MySQL database as opposed to SQL Server, then you probably need to find find a different set of forums.  These are for SQL Server, the product made by Microsoft. SQL Server has a tool called SSIS, but you will need a license to SQL Server to use it.


    Louis

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