Data not inserting into Azure Sql database

Question

It's my first time using Azure and i'm having problems.

I have a register and login script within my MVC project and it works fine on my local machine however when I try to use Azure I get this message on the page "An error occurred while processing your request."

I have allowed the IP in the firewall. I have linked the database with the site.

The project uses code first models. When I try to register it will create the table in the database but it will not input the users data. So all I'm left with is an empty table.

Also when I try to Deploy my database from Sql management studio it creates the tables but fails to input data.

What am I doing wrong?

EDIT:

So when I try to Deploy my database from SQL Management Studio this is the error I get during importing database

TITLE: Microsoft SQL Server Management Studio
------------------------------

Could not import package.
Warning SQL0: A project which specifies SQL Server 2012 as the target platform may experience compatibility issues with SQL Azure.
Error SQL72014: .Net SqlClient Data Provider: Msg 40511, Level 15, State 1, Line 2 Built-in function 'newsequentialid' is not supported in this version of SQL Server.
Error SQL72045: Script execution error.  The executed script:
ALTER TABLE [dbo].[Domains]
    ADD DEFAULT (newsequentialid()) FOR [DomainId];


 (Microsoft.SqlServer.Dac)

I think this is due to my model using GUID. Could this be what is causing all these issues with the database on Azure?

What exect error message do you get when you try to Insert or Create someting? — Venson
– Venson, Commented Dec 15, 2014 at 0:28
I'm not sure what code to show you as I just realized any page that requires the database either for user login or something else causes the An error occurred while processing your request.. Everything works locally but not with Azure. — Jacob Gardner
– Jacob Gardner, Commented Dec 15, 2014 at 0:50
Just googling "newsequentialid azure" gives a hint that you should switch to uniqueidentifier/newid() for your DomainId column. — TarasB
– TarasB, Commented Dec 15, 2014 at 22:47

user272735 · Accepted Answer · 2014-12-15 09:22:29Z

The error message pretty much describes your problem:

Warning SQL0: A project which specifies SQL Server 2012 as the target platform may
              experience compatibility issues with SQL Azure.
Error SQL72014: .Net SqlClient Data Provider: Msg 40511, Level 15, State 1, Line 2 
                Built-in function 'newsequentialid' is not supported in this version of SQL Server.

SQL Server and Azure SQL are not 100% feature compatible (even the gap has been reducing quickly):

Currently, Azure SQL Database does not support all the features of SQL Server. For a detailed comparison information, see Azure SQL Database Guidelines and Limitations. Be aware of this when you want to move an existing database to Azure SQL Database as you might need some additional budget on database redesign.

So your problem is that you're using an unsupported feature newsequentialid.

Stuart Ozer · Accepted Answer · 2014-12-15 23:33:31Z

1

Late last week Azure launched a preview of the latest version of Azure SQL DB and in that preview, NewSequentialID is now supported, along with many other features that were previously not available.

To create a database using the newest version, use the new portal at portal.azure.com and follow the guidance on-screen inviting you to use the preview edition when you create a new Azure Database.

answered Dec 15, 2014 at 23:33

Stuart Ozer

1,3947 silver badges7 bronze badges

2 Comments

Jacob Gardner Over a year ago

I have tried this however when I click on the new version it just redirects to Microsoft's home page.

Stuart Ozer Over a year ago

Does it work for you if you try the SQL Database Update Preview link on this page: azure.microsoft.com/en-us/services/preview

Blaise · Accepted Answer · 2015-07-10 16:23:20Z

The short answer is, if all you need is just a unique Guid, just change all newsequentialid() into newid().

Here is a good reference blog post Uniqueidentifier and Clustered Indexes, published by Microsoft Azure team.

In the section concerning newsequentialid(), it describe the difference:

If the NEWID() function generates unique non-sequential uniqueidentifier than NEWSEQUENTIALID() function generates unique sequential uniqueidentifier. The only trick to NEWSEQUENTIALID() function is that the GUIDs are generated partial based on the network card of the computer.

Further, newsequentialid() is not even recommended because

(i)t is possible to guess the value of the next generated GUID and, therefore, access data associated with that GUID.

Community · Accepted Answer · 2017-05-23 10:29:33Z

-1

It's difficult to say what is going on without any code, but most likely you are forgetting to commit the entries to your table. SqlCommand.Dispose() before SqlTransaction.Commit()? might help you.

edited May 23, 2017 at 10:29

CommunityBot

11 silver badge

answered Dec 15, 2014 at 0:36

manOFsnow

1

Collectives™ on Stack Overflow

Data not inserting into Azure Sql database

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related