Multi-part names ( dbo.Table.Column) with Server or Database specifier is not supported in this version of SQL Azure.

Oct 26, 2009 at 10:11 AM

I am migrating my sql express database to Azure and getting lots of errors because of the multipart column name.  Any idea how to solve this?

 

HierarchyId is not supported in current version of SQL Azure

Also I am getting. HierarchyId is not supported in current version of SQL Azure

 

 

 

Coordinator
Oct 26, 2009 at 1:32 PM

Multipart name examples:

select dbo.table.column from dbo.table where dbo.table.column2 = 5

change to something like this

select tbl1.column from dbo.table tbl1 where tbl1.column2 = 5

or

select column form table where column2 = 5

if you have something like this:

select column1 from database.dbo.table change it to select column1 from dbo.table

 

If you have a HierarchyId as a column type, then you will have to wait until SQL Azure supports it or modify your table to remove HierachyId and put a pointer to itself in the table so you can do hierarchies the old way.

 

regards