Ask a questionAsk a question
 

General Discussiondata change questions

  • Thursday, July 02, 2009 6:38 AMHelenGong Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Hi,


    1. Can I store basedata in the xml and generate them into Data Generation Plan. Any reference link to do this?
    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)

    Currently I instal GDR R2 in my computer

    Thanks








    Helen

All Replies

  • Thursday, July 02, 2009 6:58 AMJoyceWang_MSFTMSFTUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Hi Helen,

    1. I am not quite sure I understand your question. Do you mean represent the data (rows) in XML?

    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.

    -- Joyce