As per the requirement we can easily transfer the data from one table to another table in same server as well in other server by using the import/export wizard.
Schema and as well as data we can transfer at a time using the SQL Server 2008 option.
See for more Details:
http://blog.sqlauthority.com/2009/07/29/sql-server-2008-copy-database-with-data-generate-t-sql-for-inserting-data-from-one-table-to-another-table/
No comments:
Post a Comment