Post reply

Database cleaning Routines

  • 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!!!

  • 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

  • August 6, 2002 at 10:32 am

    #434106

    10X!!!!

    Thanks!!!


    Thanks!!!

Viewing 3 posts - 1 through 2 (of 2 total)

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