Database cleaning Routines

• Nitz

  SSC Enthusiast

  Points: 145

  More actions

  August 6, 2002 at 8:08 am

  #158656

  HI ALL

  I've now finished building a database and its application, I am planning on selling the application. I want to make an install disk, and I want to install a clean db - meaning (no records, no logs, I don't want logs to grow, clean identify fields). I have changed the db schema lots of time, and I have wonder maybe there a way to rebuild the db that it want have any "leftovers" from all the design changes, properties changes, records inserts and deletions.

  I am sorry for the ignorance, I hope I managed to explain my self

  Help?

  Thanks!!!

  
  Thanks!!!

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738337

  More actions

  August 6, 2002 at 8:14 am

  #434088

  I suspect you mean script the database.

  From EM, right click the database, select Generate SQL Script.

  You probably want to script the db and all objects, including indexes and roles (you are using roles, right?). Then run this script from your install.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

• Nitz

  SSC Enthusiast

  Points: 145

  More actions

  August 6, 2002 at 10:32 am

  #434106

  10X!!!!

  Thanks!!!

  
  Thanks!!!