Original text encoding changed

Analyze TSQL file changes the text encoding in the target. For example, Mykolaïvs changed to Mykolaïvs

Id #6938 | Release: None | Updated: May 11 at 7:57 PM by ghuey | Created: May 10 at 10:33 PM by Giavinh

Incorrectly remove comments

When I analyzed the TSQL script, the tool incorrectly removed the comments which contains TSQL statements inside the comment. /* USE [MyDatabase]; IF EXISTS (SELECT * FROM sys.objects WHERE objec...

Id #6937 | Release: None | Updated: May 10 at 11:57 PM by ghuey | Created: May 10 at 8:50 PM by Giavinh

"SELECT INTO statement is not supported": regex pattern match issue

If an SQL statement uses a CTE that contains an MERGE/INSERT INTO clause the regex fails. Using SQLAzureMW 3.8.6 with the pattern "SELECT[\w\W][^;]*\sINTO" against a statement such as ";WITH cte AS...

Id #6907 | Release: None | Updated: Apr 24 at 10:06 PM by ghuey | Created: Apr 24 at 9:08 AM by AndyKrafft

Changing index to a clustered index does not remove INCLUDE columns

When SQLAzureMW forces a change of an index to a clustered one (because it detects that there is no such index on a table; mandatory in Azure) it scripts the CREATE INDEX statement with the CLUSTER...

Id #6906 | Release: None | Updated: Apr 24 at 10:08 PM by ghuey | Created: Apr 24 at 8:49 AM by AndyKrafft

Operand type clash: image is incompatible with geography

Hi I have SQL 2008 Express R2 SP1 using SQLAzureMW v3.8.2. When running the migration the code is generated fine, but when I execute the script against the SQL Azure server I get the error: SQLS...

Id #6891 | Release: None | Updated: Apr 17 at 2:27 PM by JamesEinTech | Created: Apr 13 at 11:23 AM by JamesEinTech

Could not load file or assembly

I get this error right after I select Analyze / Migrate "SQL Database" and hit the next button.

Id #6825 | Release: None | Updated: Mar 8 at 1:53 PM by ghuey | Created: Mar 7 at 3:38 PM by fdbaird

Make more robust sample database

To create tests we need more records, various fields' types, different types of relationships between entities and different types of federation keys.

Id #6804 | Release: None | Updated: Feb 25 at 4:49 AM by ghuey | Created: Feb 24 at 4:08 PM by mglukhankov

Data Difference after export

I noticed a data discrepancy after I migrated from SQL 2008 r2 to windows SQL azure. The error is with primary key 2099. It did have three dots at the end of the search_code field and after the mig...

Id #6794 | Release: None | Updated: Feb 22 at 2:12 PM by ghuey | Created: Feb 22 at 3:35 AM by mattdone

Doesn't run on Compute

I tried to run the wizard on my compute instance but it doesn't start - checked the event log and got: Log Name: Application Source: Application Error Date: 2/21/2012 2:20:49 ...

Id #6792 | Release: None | Updated: Feb 22 at 12:02 AM by ghuey | Created: Feb 21 at 1:27 PM by ben555

Does not run on Windows 8

The migration wizard does not run on Windows 8, even in compatibility mode.

Id #6784 | Release: None | Updated: Feb 18 at 6:20 PM by timheuer | Created: Feb 18 at 6:20 PM by timheuer