locked
Migrate Data from one Database to another RRS feed

  • Question

  • Hi,

    I have two databases in Azure, in the same server. I want to migrate data in 3 tables in one database to other. both databases have those 3 tables.

    1. Can't I use TSQL for this

    2. I tried to use import export wizard but I am getting a time out exception

    is there any other option I can do this.

    Thank You

    Tuesday, June 23, 2015 6:00 AM

Answers

  • Hey you can follow these two different option to done with data base changes

    Option 1 - Right click on the database you want to copy

    • Choose 'Tasks' > 'Generate scripts'

    • 'Select specific database objects'

    • Check 'Tables'

    • Mark 'Save to new query window'

    • Click 'Advanced'

    • Set 'Types of data to script' to 'Schema and data'

    • Next, Next

    You can now run the generated query on the new database.

    Option 2

    • Right click on the database you want to copy

    • 'Tasks' > 'Export Data'

    • Next, Next

    • Choose the database to copy the tables to

    • Mark 'Copy data from one or more tables or views'

    • Choose the tables you want to copy

    • Finish

    Tuesday, June 23, 2015 6:54 AM