Copy tables from one database to another on Azure [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 11 years ago.

Improve this question

I have to copy tables from one database on Azure to another which is on our virtual server there on Azure. Importing is not working. What would be the way to make this. The other issue is some of the tables have different columns can I copy matched columns only? this is sql servers.

stackoverflow.com/questions/6572754/…

Nagaraj S
– Nagaraj S

2014-02-05 04:06:38 +00:00
Commented Feb 5, 2014 at 4:06 — Nagaraj S
– Nagaraj S, Commented Feb 5, 2014 at 4:06

Vignesh Kumar A · Accepted Answer · 2014-02-06 12:57:21Z

-1

SQL-Azure does not support USE statement and effectively no cross-db queries.

If you want to copy/backup the db to another sql azure db you can use the "Same-server" copying or "Cross-Server" copying in SQL-Azure. Refer this msdn article

edited Feb 6, 2014 at 12:57

answered Feb 5, 2014 at 4:03

Vignesh Kumar A

28.6k14 gold badges67 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Copy tables from one database to another on Azure [closed]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related