RowGuid suggestion

May 10, 2011 at 3:16 PM
Edited May 10, 2011 at 3:17 PM

Hi to all, it's my first post.

Since the "RowGuid" table row property isn't supported by SQL Azure, why don't give the possibility in the Migration Wizard to choose to have the script generated with something like:

 

CREATE TABLE MyTest ( 
     MyID UNIQUEIDENTIFIER DEFAULT NEWID() PRIMARY KEY, 
[...]

if MyID column has the RowGuid property active in the source DB?

For me, having 100+ tables to migrate each one with this property active, it would be "a dream" :)

 

Davide

PS: I searched in the discussion archive and i haven't found something like this (so, sorry if there is...)

May 10, 2011 at 3:54 PM
Edited May 10, 2011 at 3:54 PM

I'm sorry... I've just noticed that the sw does it writing it on the end of the script...