Sample Header Ad - 728x90

How to execute complete database script without checks on objects existence

0 votes
1 answer
140 views
I'm working on a customer data archiving. I created a complete database script to prepare the new database for archiving data with the same DB schema of the production one. At the moment I'm preparing a Test environment to verify all the steps we will execute in in production later, but the script is, obviously, raising a lot of errors because of missing external database's views, functions and stored procedure being referred to. Is it possible to switch off objects existence during the script execution, so I can create the complete database schema to make my tests? --- I decided to proceed with tests about restoring the whole production database and then clear all tables data. To clear the data I will try suggestions I found in replies to this question in Stack Overflow, to be precise these two: - https://stackoverflow.com/a/12719464/21116580 - https://stackoverflow.com/a/22527902/21116580 I will come back as soon as I'll complete my tests with the results.
Asked by El See (1 rep)
May 20, 2024, 03:29 PM
Last activity: Aug 3, 2025, 05:05 AM