Can we create destination database instance in the same machine where source database instance exist in windows machine to carry out Agile database upgradation ?
Yes this can be done and there are two approaches to this. Out of place (new DB Instance) and In place (same DB instance ) for the upgrade.
When upgrading using new database instance, after installation of db, there is a script called useragile.sql needs to be run to create empty user in target agile db instance.
But , how to run the script ? Is it by connecting agile db using regul