Sql Server Question - Posted (837 Views)
Advanced Member
Carefree
Posts: 4224
4224
Is there an easy way to strip all the data from a Sql Server database (retaining structure, etc)? I exported it, opened in Access and deleted it all ... only to find that I can't "upsize" it to Sql 2012.
 Sort direction, for dates DESC means newest first  
 Page size 
Posted
Forum Admin
HuwR
Posts: 20611
20611
just create a script that does a TRUNCATE [TABLENAME] on all the tables

however be careful as the forum requires some data or it will not run smile ie it needs the config table, and a default forum and an admin user
 
You Must enter a message