Generating fresh database from existing

[review000]

I know lots of you know this, but let me share it

First go to your database,
Login then

Right click your Database, e.g. (RanGame1)
Choose task, under Task, Choose Generate Script
then Next until it finish generating script.
Then one of the step asking for the path of the output script.
Change it if you like to change the output path and name..

After Generating the script go to the path where you put the output file.
Open it, then delete the existing database(in this Example delete RanGame1)(do it on your on risk), after deleting execute the generated script..

then you have your fresh database.

 

[baby011528]

double check about procedures in db.
if i not wrong , generate scripts is exclude of procedures.

 

[review000]

I think all procedures are checked in default
if not just check the "Script entire database and all database objects" in Choose Objects tab

 

[baby011528]

I think all procedures are checked in default
if not just check the "Script entire database and all database objects" in Choose Objects tab

oops , i just tested and it can choose table views and procedure.
so this method is suitable for them who want to take the fresh db without truncate it by themself.

thanks for sharing.
learn something in here.

 

[review000]

oops , i just tested and it can choose table views and procedure.
so this method is suitable for them who want to take the fresh db without truncate it by themself.

thanks for sharing.
learn something in here.

yes that's the purpose of that, but just to be safe check all the procedures.
to avoid conflict or bugs ingame

 

[baby011528]

yes that's the purpose of that, but just to be safe check all the procedures.
to avoid conflict or bugs ingame

yes , i try this method before , but maybe is long time ago fuzzy memory about this.
thanks for pointing me.

 

[Lars]

Instead of creating a new one, you can just use the current one.

Click

You must be registered to see links

--Either way, good job TS for sharing.

 

[baby011528]

have many method that can done it.

for me , i using query to list out the table name. and choose which table that i want to truncate.
because my rancp read my itemtable from db.

btw , for who needs can use too .

use [DBNAME] /* RanGame1/RanLog/RanShop/RanUser */

select 'Truncate Table ['+name+']' from sys.tables