Sql Server Question - Postet den (839 Views)
Advanced Member
Carefree
Innlegg: 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.
   
 Sidestørrelse 
Postet den
Forum Admin
HuwR
Innlegg: 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
 
Du må legge inn en melding