Moving database

  • Hi,

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

    in advance thank you.

  • Make the DB in full recovery mode.

    Place .mdf and .ldf files in different drives.

    and Wait for other experts comment 😀

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

    Gethyn Elliswww.gethynellis.com

  • Add it into the backup rotations.

  • 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

  • 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