MS-SQL update Script
Finally we want to use MS-SQL so we can share the connectoins. But our MS-0SQL support team want first get the Update SQL script before they setup the database. But you can see the script only until the database conenciton is there (chicken-egg problem).
Where can I get the complete MS-SQL udpate script that the MS-SQL support can run to set the whole database up?
All Comments (2)
We no longer display the SQL DB create script in RDM anymore since it was causing havoc for the support team. We would end up with databases with half of the schema (missing triggers/views/defaults/indexes) or even worse sometimes without proper execution rights (we use execute as owner on a few triggers).
You have three choices:
1 - Let RDM create the database and schema
2 - Use RDM to create the database on a test server then script it using SSMS. Warning!!! make sure you script the entire database schema including views/procedures/triggers/defaults/indexes/primary keys... You get the idea. You can then analyze the result and execute it on your production server.
3 - I could send you the script via private message or email. I would need to know what version of RDM the you are running.
Please note, if you choose the option #2 or #3 and then encounter issues after the fact that are linked to this then you will require a support agreement prior to receiving one on one support.
Best regards,
Stéfane Lavergne
Thanks Stefane for all the help!