Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How to develop ETL tool in SQL server

Author  Topic 

chidambaramkkc
Starting Member

2 Posts

Posted - 2012-09-26 : 11:58:52
I am a new to SQL server. I want to transfer the data one database to another database. I don't know how to use an ETL tool in SQL server.

chidambaram

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-09-26 : 12:05:45
If its a simple database to database transfer you can use export import task
Right click on source database go to tasks -> options -> export data and choose destination database and tables when prompted by wizard

you may execute package without saving or save it as a package (.dtsx file) for future use too

if both databases are in same server you can even use t-sql with query like

insert into dest.dbo.table
select columns from source.dbo.table

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

chidambaramkkc
Starting Member

2 Posts

Posted - 2012-09-26 : 12:40:09
Thanks for your sending replay,
In SQL server screen where is the ETL tool. I can't find it. (Sorry, I am on a server we move to data from mysql to SQL server. I don't have any idea about this. Please send me any other reference site or something. I want to clear this issue few days).

Thanks
chidambaram..
Go to Top of Page

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-09-26 : 13:19:09
The ETL tool is SSIS (SQL Server Integration Services). The development environment is called SQL Server Business Intelligence Development Studio (BIDS) or SQL Server Data Tools under the SQL Server Program group.

You will find lot of tutorials on the web if you google, e.g.: http://msdn.microsoft.com/en-us/library/ms169917(v=sql.105).aspx
Go to Top of Page
   

- Advertisement -