SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

chidambaramkkc
Starting Member

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

chidambaram

visakh16
Very Important crosS Applying yaK Herder

India
52317 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
http://visakhm.blogspot.com/

Go to Top of Page

chidambaramkkc
Starting Member

India
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).

Thanks
chidambaram..

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

sunitabeck
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.: http://msdn.microsoft.com/en-us/library/ms169917(v=sql.105).aspx
Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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.05 seconds. Powered By: Snitz Forums 2000