All geek questions in one place

Use SQLMetal in Azure SQL Database

For reasons that I would not want to discuss, our main database schema is currently only in SQL Azure. We are working on its local use with a tool like Enzo Backup (we are waiting for their developers to fix the errors that we received when trying to download), but in the meantime I would like to create a Linq-to-Sql ORM from the Azure DB SQL schema. When I try to do this, the output generates a bunch of error messages like this:

Warning: SQM1012: Cannot retrieve table 'dbo. [TableName] 'from SqlServer. Invalid object name 'syscomments'.

Is it even possible to create an ORM mapping from an Azure SQL database?

Edit

Please note that generating scripts from SSMS does not work even in the newest version (2008 R2). You get the following error in the generated report when you try to generate scripts in an instance of the Azure SQL database, and it does not work before processing even the first object:

System.IndexOutOfRangeException: The index was outside the array. in Microsoft.SqlServer.Management.SqlScriptPublish.GeneratePublishPage.worker_DoWork (Sender Object, DoWorkEventArgs e) in System.ComponentModel.BackgroundWorker.OnDoWork (DoWorkEventArgs e) in System.ComponentModel.BackgroundWorkerWorkerWorkerWorkerWorkerWorkerWorker

Edit 2

I just tried using the free SMOscript tool and it generates the same error message:

Objects in database [DatabaseName] on server [ServerAddress]: Error: Index was outside the bounds of the array.

Thus, it looks like it is easy to create DDL scripts, and it can be talk at the SMO level for 2008 R2 against SQL Azure DB.

+1
source share
1 answer

Everything seems to be returning to SMO. I finally installed 2008 R2 SP1 and worked on my computer, and it looks like I can generate the scripts correctly (finally). Thanks for all your help!

0
source

Source: https://habr.com/ru/post/1340657/

More articles:


All Articles