topic Re: Copy data from one SQL server database to another in Talend Studio

Copy data from one SQL server database to another

_AnonymousUser — Sat, 16 Nov 2024 11:37:43 GMT

I have copied data from Excel sheets to the multiple tables of a SQL server.
I want to copy data from these tables of one SQL server database to another database. How do I do that?
Note: Since it is a complete refresh I need to delete data from the destination database before copying the data.
Please tell me how do I go about this two tasks?

Re: Copy data from one SQL server database to another

Anonymous — Wed, 28 May 2014 04:14:37 GMT

Hi,
It seems you want to migrate one SQL server database to another database?
If so, could you please have a look at related https://community.talend.com/t5/Design-and-Development/complete-migration-from-oracle-to-sql-server/td-p/106789. Let me know if it is OK with you.
Best regards
Sabrina

Re: Copy data from one SQL server database to another

Anonymous — Wed, 28 May 2014 05:47:55 GMT

Hi Yuvraj,
That "another database" is same sql server or another? If it is different you can do in following way
- tSQLServerInput-->main-->tyourdatabaseoutput (use truncate and load option if you want to remove all earlier data before loading)
- If the database is same, you can also think of using SQLRow component and use database copy command sql

Whether you are facing any problem in doing this?
Vaibhav

Re: Copy data from one SQL server database to another

Anonymous — Wed, 28 May 2014 07:22:32 GMT

Youraj, please check tTransferDatabase component on exchange it is very well for transform database.
http://www.talendforge.org/exchange/?eid=457&product=tos&action=view&nav=1,1,1

Re: Copy data from one SQL server database to another

Anonymous — Thu, 29 May 2014 09:05:13 GMT

Hi Yuvraj Solanki,
Is there any update for your issue?
Best regards
Sabrina