Select to view content in your preferred language

Archiving a database not working

295
1
03-26-2024 03:51 PM
KhanMortuzaBinAsad
New Contributor

I was trying to archiving a table of my organization database. I marked the connection properties from Traditional to Branch as suggested.

KhanMortuzaBinAsad_1-1711493010393.png

It is saying cannot do it on a view. Could you please help me to find a way to archiving the table? I need to do it for a change detection project (change of geometry over time). Thank you in advance!

KhanMortuzaBinAsad_0-1711492969666.png

 

0 Kudos
1 Reply
CodyPatterson
Regular Contributor

Hey @KhanMortuzaBinAsad 

If you have access to your SQL Server Management Studio or the database where this is stored, would you be able to check to see if this table is currently a view? You may be allocated a view for read-only access from your database administrator to ensure no changes are made. Changing to versioning will create a view from the table itself, I assume that using a view already will cause issues with such. Archiving will create separate columns on the table as well, views may not have the ability to make these changes as well.

Hope that helps to some extent! I will try and help where I can!

Cody

0 Kudos