menu
Logo
  • Why azing?
  • Blog
  • Help
ENarrow_drop_down
  • DE
  • EN
Suche in Checklisten
search
azing Logo ENarrow_drop_down
  • DE
  • EN
  • Why azing?
  • Help
2sxc
drive_folder_upload
  • homeChecklist Templates
  • south
  • fiber_manual_recordInstallation and Updates
  • south

folder_sharedUninstall 2sxc

  • homeChecklist Templates
  • south
  • fiber_manual_recordInstallation and Updates
  • south

folder_sharedUninstall 2sxc

Folders and checklists

  • check_circleRemove all 2sxc SQL Server Tables after Unistalling 2sxc

Parts (2) expand_more

These are small document-parts which are used in other documents. They are not a starting point for any real activity. Because of this, they will be listed further down and the search will not list them unless requested. 

  • infoSQL script to create 2sxc schema with minimal data
  • infoSQL script to remove 2sxc schema and data from DNN db in one pass

For safety uninstalling 2sxc doesn't remove the tables. Use this to do it manually for 2sxc v8 up to v11:

  1. Make sure you are on the right DB!
  2. Copy the following script and run it a few times
    You'll see errors about constraints from other tables, but every time you run it a few more tables are gone till all are removed.
Drop Table if Exists dbo.ToSIC_EAV_Apps
Drop Table if Exists dbo.ToSIC_EAV_AssignmentObjectTypes
Drop Table if Exists dbo.ToSIC_EAV_Attachments
Drop Table if Exists dbo.ToSIC_EAV_AttributeGroups
Drop Table if Exists dbo.ToSIC_EAV_Attributes
Drop Table if Exists dbo.ToSIC_EAV_AttributeSets
Drop Table if Exists dbo.ToSIC_EAV_AttributesInSets
Drop Table if Exists dbo.ToSIC_EAV_AttributeTypes
Drop Table if Exists dbo.ToSIC_EAV_ChangeLog
Drop Table if Exists dbo.ToSIC_EAV_ContextInfo
Drop Table if Exists dbo.ToSIC_EAV_DataTimeline
Drop Table if Exists dbo.ToSIC_EAV_Dimensions
Drop Table if Exists dbo.ToSIC_EAV_Entities
Drop Table if Exists dbo.ToSIC_EAV_EntityRelationships
Drop Table if Exists dbo.ToSIC_EAV_Values
Drop Table if Exists dbo.ToSIC_EAV_ValuesDimensions
Drop Table if Exists dbo.ToSIC_EAV_Zones

 

  1. To remove the stored procedures use this
Drop Procedure If Exists dbo.ToSIC_EAV_ChangeLogAdd
Drop Procedure If Exists dbo.ToSIC_EAV_ChangeLogGet
Drop Procedure If Exists dbo.ToSIC_EAV_ChangeLogSet
Drop Procedure If Exists dbo.ToSIC_EAV_DeleteApp
Drop Procedure If Exists dbo.ToSIC_EAV_LogToTimeline

 

Logo
Legal | Content Copyright CC-BY 4.0
bug_reportReport Bug
  • info
  • Links
  • Permissions
code Share
code
URL copied to clipboard.
Embed Checklist close
Copy Copy
Content Copyright

CC-BY 4.0

Translations

None

2sxc - Content Management for DNN & Oqtane Logo

2sxc - Content Management for DNN & Oqtane

QR-Code
azing.org/2sxc/r/Sa6-Qbyy
View & Use

Public (can be used by everybody)

Edit & Admin

Default (all members can edit)

This catalog has a simple permission model, where all members have the same permissions. For advanced permissions, upgrade to Enterprise.

Here you can see how this document is used and linked by other documents

Used in (0)

Others referencing this

Uses these (0)

Documents linked from this document

How it Behaves

How this document is categorized changes how it behaves.

This is a main document, it is listed normally and appears in search result.

Type

This is a Checklist. Lists are converted into checkboxes.

Get something to say?

Comment to start a discussion or make a note
send

please log on to chat

close

Durchsuche ganz Azing