locked
Migrating RRS feed

  • General discussion

  • How to migrate data structure from one sql server to other sql server database table.
    Wednesday, July 31, 2013 8:43 PM

All replies

  • By data structure you mean all tables,indexes ,Sp,triggers etc..best is backup restore.

    if you want to just create table ..rk on table and do create to in new query editor windows this gives youo query run it on other SQL serevr to create table of same structure,then use SSIS or imp/exp wizard to mgrate data.

    If you want to transfer data ..SSIS,impirt export method can be used.


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Thursday, August 1, 2013 7:39 AM
  • I want to migrate only some columns structure and data into other server database table.
    Thursday, August 1, 2013 7:10 PM
  • Hi Reddy,

    You can use Replication methods to migrate your database structure.Replication facilitates you to migrate/ transfer selected columns to your new server.



    Sunday, August 11, 2013 5:19 PM