data change questionsHi,<br/> <br/> <br/> 1. Can I store basedata in the xml and generate them into Data Generation Plan. Any reference link to do this?<br/> 2. Any data loss risk involved in GRD R2? ( I know before GRD R2, we could have data loss if we rename a column in a table)<br/> <br/> Currently I instal GDR R2 in my computer<br/> <br/> Thanks<br/> <br/> <br/> <br/> <br/> <br/> <br/> <br/><hr class="sig">Helen© 2009 Microsoft Corporation. All rights reserved.Thu, 02 Jul 2009 06:58:34 Za05fb549-f0cc-46c9-8495-504b2dd55644http://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/a05fb549-f0cc-46c9-8495-504b2dd55644#a05fb549-f0cc-46c9-8495-504b2dd55644http://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/a05fb549-f0cc-46c9-8495-504b2dd55644#a05fb549-f0cc-46c9-8495-504b2dd55644HelenGonghttp://social.msdn.microsoft.com/Profile/en-US/?user=HelenGongdata change questionsHi,<br/> <br/> <br/> 1. Can I store basedata in the xml and generate them into Data Generation Plan. Any reference link to do this?<br/> 2. Any data loss risk involved in GRD R2? ( I know before GRD R2, we could have data loss if we rename a column in a table)<br/> <br/> Currently I instal GDR R2 in my computer<br/> <br/> Thanks<br/> <br/> <br/> <br/> <br/> <br/> <br/> <br/><hr class="sig">HelenThu, 02 Jul 2009 06:38:50 Z2009-07-22T00:19:48Zhttp://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/a05fb549-f0cc-46c9-8495-504b2dd55644#edb114cc-1673-4309-9100-304d87f7c032http://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/a05fb549-f0cc-46c9-8495-504b2dd55644#edb114cc-1673-4309-9100-304d87f7c032JoyceWang_MSFThttp://social.msdn.microsoft.com/Profile/en-US/?user=JoyceWang_MSFTdata change questionsHi Helen,<br/><br/>1. I am not quite sure I understand your question. Do you mean represent the data (rows) in XML?<br/><br/>2. We improved our deployment mechanism so that we avoid the potential data loss as much as possible. In the specific case you mentioned, rename a column in a table, deployment uses sp_rename (instead of drop and recreate) to change the column name.<br/><br/>-- JoyceThu, 02 Jul 2009 06:58:34 Z2009-07-02T06:58:34Z