I have created a new database on my hosts server (blank-no tables) using SQL Server Management Studio to copy the tables, stored procs etc. The tables and data are being created and transfer but the stored procs are not. Is this because of permissions set on them locally? I am using open-source version.
How can I get the database transfered to my host without having them attach it manually on their end?
Thanks,
Brian
The reason that you cannot transfer the functions, procedures and views is because they are encrypted. There are only three ways to get the database onto a hosted service: 1) send the MDF file and have them attach it, 2) license SplendidCRM Professional and use the SQL source code to populate the database, or 3) have our support staff populate the database for you.
If you have made any customizations to the database, then you will have to apply them separately.
