I am automating my DB deployments using XML script.
I have created XML scripts which compares and synchronizes databases.
Now I want to create a XML script which compares databases and generates a script, that I can run on the database anytime later manually. I need this for rollback.
I am new to red-gate and dont know what commands shud I use for generating scripts.
I tried with /verbose option and redirected output to a file. It only generated the differences, not the script.
Can anyone please help?