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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How to develop ETL tool in SQL server
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

2 Posts

Posted - 09/26/2012 :  11:58:52  Show Profile  Reply with Quote
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.


Very Important crosS Applying yaK Herder

52326 Posts

Posted - 09/26/2012 :  12:05:45  Show Profile  Reply with Quote
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

Go to Top of Page

Starting Member

2 Posts

Posted - 09/26/2012 :  12:40:09  Show Profile  Reply with Quote
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).


Edited by - chidambaramkkc on 09/26/2012 12:43:13
Go to Top of Page

Flowing Fount of Yak Knowledge

5155 Posts

Posted - 09/26/2012 :  13:19:09  Show Profile  Reply with Quote
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.:
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000