Post reply

Moving database

  • March 16, 2009 at 7:19 am

    #207009

    Hi,

    Can any one suggest me what things i have to consider while moving database from development environment to production.

    in advance thank you.

  • March 16, 2009 at 7:22 am

    #960193

    Make the DB in full recovery mode.

    Place .mdf and .ldf files in different drives.

    and Wait for other experts comment 😀

  • March 16, 2009 at 7:23 am

    #960199

    proably need to consider security too assuming that permissions and data access will differ between development and production

    Gethyn Elliswww.gethynellis.com

  • March 16, 2009 at 7:25 am

    #960200

    Add it into the backup rotations.

  • March 16, 2009 at 2:27 pm

    #960580

    amarnath_sk (3/16/2009)

    Hi,

    Can any one suggest me what things i have to consider while moving database from development environment to production.

    in advance thank you.

    Well, Stress analysis, Performance baseline and Orphan users these are the primary factors that you can consider. After migrating, monitor the database growth and set your backup strategy accordingly and also maintenance on your database.

    Hope this helps

  • March 18, 2009 at 8:21 am

    #961926

    Hi:

    You can use FTp command .

    Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply