Sunday, 15 September 2013

SQL Azure doesn't support 'select into' - Is there another way?

SQL Azure doesn't support 'select into' - Is there another way?

I have a very complicated table I'd like to take a temporary backup of
whilst I make some changes. Normally, I'd just do the following:
SELECT *
INTO temp_User
FROM dbo.[User] AS u
Unfortunately I'm using Azure, and it appears this isn't supported:
Msg 40510, Level 16, State 1, Line 2 Statement 'SELECT INTO' is not
supported in this version of SQL Server.
Is there a way to re-create this feature into a function, potentially? I
could do this by scripting the table, creating it and then inserting data
using a select statement but given how frequently I use Azure, and how
many databases I need to work on in this area this is very unwieldy.

No comments:

Post a Comment