How we change our starter kit database schema in the database?

Discussion in 'Databases' started by ddeepak, May 29, 2007.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Hi,

    we have already create the starter kit database schema in the database but we need to ceratin change in the database schema. when we use the osql in MS DOSagain it gives message:- There is already an object named " Events" in the database. And do not changes in the schema.

    How we recreate the changes stater kit database schema in the remotedatabase ?



    Regards,
    DD
     
  2. If your tables are not yet populated,the best solution is to delete all the exisiting tables and recreate the schema from scratch(attach the mdf or run the sql script) ,otherwise you will have to modify the sql script accordingly to omit re-creation of existing objects,which might be a little complex,if there are many tables,storedprocedures,views etc.btw which starter kit are you referring to and why do you need to re-create the schema?Are you having problems with your application?

    Vikram

    DiscountASP.NET
    www.DiscountASP.NET
     
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