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.
| 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 taskRight click on source database go to tasks -> options -> export data and choose destination database and tables when prompted by wizardyou may execute package without saving or save it as a package (.dtsx file) for future use tooif both databases are in same server you can even use t-sql with query likeinsert into dest.dbo.tableselect columns from source.dbo.table------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
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).Thankschidambaram.. |
|
|
|
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 |
|
|
|
|
|
|
How to develop ETL tool in SQL server