Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Community Discussions (All other subjects)
 Sql Server Question		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Carefree
Advanced Member

Philippines
4217 Posts
Posted - 20 April 2012 :  04:39:40  Show Profile  Reply with Quote
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.

HuwR
Forum Admin

United Kingdom
20595 Posts
Posted - 20 April 2012 :  05:53:38  Show Profile  Visit HuwR's Homepage  Reply with Quote
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
MVC .net dev/test site | MVC .net running on Raspberry Pi
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.34 seconds. Powered By: Snitz Forums 2000 Version 3.4.07