Archiving a database not working

Question

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

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!

CodyPatterson · Answer

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