March 13, 2009

How to deploy database in production server

Few ways ....
1) If you have all the scripts for all objects.. then create new db run the scripts.
2) Backup database and restore on to production
3) Deattach-reattach to production.
at

1 comment:

Anonymous said...

get the outlook password recovery utility to fix data corruption issues in the files of specified format

August 22, 2010 at 1:30 AM

Post a Comment

Subscribe to: Post Comments (Atom)

Stop Memorizing SQL Part 3 : A Practical SQL Cheat Sheet for Beginners

 A Practical SQL Cheat Sheet for Beginners When learning SQL, students often struggle to remember the correct syntax during exams or practic...

  • Oracle Scheduled Jobs
    1. To change the scheduled time of oracle job and force it to run at certain time, use the set_scheduler_attribute procedure.e.g. To start j...
  • Move distribution database to another drive
    Move distribution database to another drive: There are scenarios in SQL server Replication that we need to move datafiles and logfiles of di...
  • Pros and Cons of stored procedures
    * Stored procedures generally result in improved performance because the database can optimize the data access plan used by the procedure an...