DB copy to dev server and UPdate db after updating

Question

 Hi, 

I would like to copy required tables to server and I will do modifications in the tables. after modification I will  Update the tables in Server. Am Making modifications in the copy of production db. Don't want to perform huge operations directly to the db as it impacts 

 

as of now I am using caching. storing table objects in caching and modifying it and updating it to database.

 

Problem with this technique is I need  latest data every time. so I have to clear and load cache again and again whenever I need to run the application (it takes time). and in dev environment, if multiple users working in same machine, one user clears cache of others while working.

 

Any ideas pls.  (asp.net sql)

Answer 1

i also having that issue

ito solve this i have coded my Own Encryption and decryption Function

and Stored Setting like

below

             <Settings>
            <setting name="server" serializeAs="String">
                <value>75ƒ105ƒ114ƒ116ƒ97ƒ110ƒ45ƒ80ƒ67ƒ92ƒ83ƒ81ƒ76ƒ69ƒ88ƒ80ƒ82ƒ69ƒ83ƒ83ƒ</value>
            </setting>
            <setting name="username" serializeAs="String">
                <value>115ƒ97ƒ</value>
            </setting>
            <setting name="password" serializeAs="String">
                <value>49ƒ50ƒ51ƒ52ƒ53ƒ</value>
            </setting>
            <setting name="databasename" serializeAs="String">
                <value>103ƒ119ƒ101ƒ100ƒ99ƒ</value>
            </setting>
            <setting name="gwedcConStr" serializeAs="String">
                <value>68ƒ97ƒ116ƒ97ƒ32ƒ83ƒ111ƒ117ƒ114ƒ99ƒ101ƒ61ƒ75ƒ105ƒ114ƒ116ƒ97ƒ110ƒ45ƒ80ƒ67ƒ92ƒ83ƒ81ƒ76ƒ69ƒ88ƒ80ƒ82ƒ69ƒ83ƒ83ƒ59ƒ85ƒ115ƒ101ƒ114ƒ32ƒ73ƒ100ƒ61ƒ115ƒ97ƒ59ƒ80ƒ97ƒ115ƒ115ƒ119ƒ111ƒ114ƒ100ƒ61ƒ49ƒ50ƒ51ƒ52ƒ53ƒ</value>
            </setting>
            <setting name="LogedUser" serializeAs="String">
                <value />
            </setting>
            <setting name="adminuser" serializeAs="String">
                <value>97ƒ100ƒ109ƒ105ƒ110ƒ</value>
            </setting>
            <setting name="adminpass" serializeAs="String">
                <value>49ƒ50ƒ51ƒ52ƒ53ƒ</value>
            </setting>
        </Settings>
    </userSettings>
        
    

if Anyone Have better Idea Tell me too .....