So I have access of two databases that are stored in Azure, and using SQL Server 2012 to access them. All I need to do is copy a table from one db and duplicate and create it in another. I keep reading everywhere that all you have to do to bring up the import and export wizard and right click the db, go to tasks and then the option for the wizard will be right there. But I cannot find it in the menu anywhere! I feel like I'm crazy or something, but I hope this is a simple solution! Here is a screenshot of what I am seeing. Any help would be greatly appreciated! Thanks!
Best Answer
The import/export wizard is not showing because it is not available for Azure SQL. Even if you downloaded the latest version of SSMS, you shouldn't see it.
You are in a different environment that how on-premise SQL Server databases work. In that Azure SQL does not support using cross database queries. So doing an
insert into or select insertare not going to work.Depending on how big the table is, your easiest thing to do is using the script object wizard and just include the data. Then just run that under the destination database.
If you need to do this on a routine basis then look at the data sync services Azure offers.