Copy data from one SQL server database to another

One Star

Copy data from one SQL server database to another

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

Re: Copy data from one SQL server database to another

Hi,
It seems you want to migrate one SQL server database to another database?
If so, could you please have a look at related forum 18793 topic: complete migration from oracle to sql server. Let me know if it is OK with you.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Copy data from one SQL server database to another

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

Re: Copy data from one SQL server database to another

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
Moderator

Re: Copy data from one SQL server database to another

Hi Yuvraj Solanki,
Is there any update for your issue?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch