How to copy azure tables with entries

Question

I am looking to copy some lookup tables that are currently on windows azure. I do not believe trhere is a way to do this through sql server management studio so I'm wondering the best way to do this other than scripting them out by hand

Are you looking to copy tables in SQL Database or Windows Azure table storage? — mcollier, Aug 27 '12 at 12:54

score 2 · Answer 1 · answered Aug 27 '12 at 13:07

2

You would typically use the SQL Database Migration Wizard (SQLAzureMW) for any task involving moving data from and to SQL Azure. This tool knows what is and what isn't supported in SQL Azure and will be more effective than manually creating the scripts.

answered Aug 27 '12 at 13:07

Sandrino Di Mattia

24,739
2
60
65

paparazzo · Answer 2 · 2012-08-27T13:35:49.030

1

Select into will create and copy the table but will not create indexes or constraints.

INTO Clause (Transact-SQL)

In SSMS your can right click a table and select generate to create a script. Then you can edit the table and other names and run the script.

edited Aug 27 '12 at 13:35

answered Aug 27 '12 at 13:04

paparazzo

44,497
23
105
176

8

`SELECT INTO` is not supported in SQL Azure. – Paul Fleming Apr 07 '13 at 07:32

score 0 · Answer 3 · edited May 23 '17 at 10:27

0

Found the answer here, it was easier than I could have hoped!

What is the best way to auto-generate INSERT statements for a SQL Server table?

edited May 23 '17 at 10:27

Community

1
1

answered Aug 27 '12 at 13:21

James

2,951
8
41
55

You will need to change the **Script for the database engine type** option to **SQL Azure Database** – Sandrino Di Mattia Aug 27 '12 at 13:25

How to copy azure tables with entries

3 Answers3