Deactivate DatabasesEstimated reading time: 1 minute
Following are the steps required to deactivate specified databases in your initial upload
- Run the script below to see a list of all databases Interject will import
--List all imported DBs SELECT * FROM [ImportERP].[SourceDatabaseList]
- You must mark as inactive the DBs you wish to exclude using the following script
--Deactivate selected DB UPDATE [ImportERP].[SourceDatabaseList] SET [Inactive] = 1 WHERE [DatabaseName] = '[DeactivateDatabase2]'
If a database is made inactive after the initial load, data that was initially imported will still be in Interject and can be used to report from. However new data will stop flowing into interject.
Continue following these steps to complete the upload