CodeCloudy

Azure | .Net | JQuery | Javascript | Umbraco

SQL Azure migration: Built-in function ‘TEXTPTR’ is not supported in this version of SQL Server.

Not only ‘TEXTPTR’  also ‘READTEXT’ is not supported in SQL Azure.

You will find this issue when you try to execute an old version of AspState script in sql azure.

You will wonder why sql azure does not support most of the new features. it’s because the sql azure was built without the deprecated features of SQL SERVER 2008 R2.

executing the new version will solve the issue.

you can get the new version here: http://azuresqlsession.codeplex.com/

 

SQL Azure Migration Wizard (SQLAzureMW) is a cool tool that will help us analyze the issues on SQL AZURE migrations.

you can download it from here: http://sqlazuremw.codeplex.com/

6 Comments »