Hi, I have just started using SQL server 2008 and needed help with transfer of table(including data) from one databse to another residing in different unconnected sql server. I have to migrate data and table structure from one sql server database to another for a particular table. Please suggest ways and guide me on how to go about doing this.

The connectivity must exist, and you need to use the Transfer Object task with the migrate data option turned on. See this how to: http://www.mssqltips.com/sqlservertip/2064/transfer-database-task-and-transfer-sql-server-objects-task-in-ssis/Arthur My Blog

The connectivity must exist, and you need to use the Transfer Object task with the migrate data option turned on. See this how to: http://www.mssqltips.com/sqlservertip/2064/transfer-database-task-and-transfer-sql-server-objects-task-in-ssis/Arthur My Blog

Use the Import/Export Wizard in SSMS. While you will be importing it will ask you to create the table exactly like your source. http://msdn.microsoft.com/en-us/library/ms141209.aspx Thank youhttp://sqlage.blogspot.com/

Use the Import/Export Wizard in SSMS. While you will be importing it will ask you to create the table exactly like your source. http://msdn.microsoft.com/en-us/library/ms141209.aspx Thank youhttp://sqlage.blogspot.com/

I would say that you have to backup the database and restore in to the new SQL instance. Now, you can easly transfer the data between database using Import and export wizard. Or Export the SQL data to a text file and create table object script from unconnect sql server and create the table from the Script file and import data from the text file.Thanks Ayyappan Thangaraj, http://SQLServerRider.wordpress.com

As alternative to SSIS you can use a linked server. http://sqlblog.com/blogs/buck_woody/archive/2010/03/16/using-linked-servers-openrowset-and-openquery.aspxBest Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/ Blog : MS SQL Development and Optimization Blog : Large scale of database and cleansing

so many solution top :)Thanks, Jed deng