Microsoft.AspNetCore.Mvc.Localization.LocalizedHtmlStringSql Server Question

Sql Server Question

Printed from: Snitz™ Forums 2000
URL: https://forum.snitz.com/forumTopic/Posts/70196?pagenum=1
Printed on: 05 November 2025, 08:47

Topic

Author : Carefree
Subject : Sql Server Question
Posted : 20 April 2012, 04:39
Message :

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.

Replies ...

Reply Author: HuwR
Replied on: 20 April 2012, 05:53
Message:

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

ie it needs the config table, and a default forum and an admin user