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/
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).
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.
How to develop ETL tool in SQL server
Posted - 09/26/2012 : 11:58:52
