[dba-SQLServer] Upsize wizard and named queries

Susan Harkins harkinsss at bellsouth.net
Fri Jan 20 18:50:25 CST 2006


I thought that someone said I needed to pull all SQL out of properties and
create named queries so that the upsize wizard could upsize them.  I did so
but I am not seeing any indication that the saved queries are being upsized?

=======Not all queries will upsize correctly. If you have the book that
Martin and I did together, he mentions a number of problems you have to fix
before upsizing. I'd look up the page if I had a copy handy, but I don't
right this minute. If you don't have it, Martin or I could probably create a
short list of gotchas. 

Susan H. 




More information about the dba-SQLServer mailing list