bak db in local ?

Discussion in 'Databases' started by sunny06, Mar 8, 2012.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. How can I do to easily work in local on a database.
    Can I update ma local database with a backup on sql server express 2008 ... can I create a backup from sql server express 2008 and update ma db online ?
    Thanks
     
  2. RayH

    RayH DiscountASP.NET Lackey DiscountASP.NET Staff

    I guess it really depends on what you're trying to do? If you need to perform some major changes to the production database, I suggest you back it up through the Control Panel, download it, and then restore it locally to work on it. Then make a backup locally, upload it, and restore it to your production database (assuming you account for any database updates in between that time). Otherwise, if it's minor changes, make the alterations locally using T-SQL to ensure the changes are what you want, and then run the scripts against the production database when you're ready.
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page