Greetings People, i just wanted to know it, can we run sql queries against k2server database, what is k2's Policy ?
Does K2 Permit running Sql queries on K2server Database ?
+8
+3I do not know what K2's policy is on it.
I have created lots of queries on their tables, but they could always update the schema with a new release that might break it.
I have found the best starting point is to use data adapters, point it at the k2 server and build / modify the queries from inside visual studio.
- John
+8I am not planning to write any queries on top of k2's db but do want to know k2's policy on it. what is k2's policy on it ?
+3why would they have any policy at all? what is Microsoft's (or K2's) policy on writing queries on their system tables? you can do it and they don't care what you do, but Microsoft (or K2) can change their tables anytime they want and it might break your query. When that happens you just change your query.
I guess I don't understand the question or the problem
+8Companies do have some policies around use of their data structures, e.g . there could be a policy that direct insert/delete Sql are not allowed and it could be violation of policy and as far as i remember Microsoft do have some sort of policy around MCMS
+8I think _cyclops_ just shared what i was looking for, so there is some policy which prohibits use of queries on their transaction db, if you do you would not be supported in your actions
+9- Nintex Partner
Direct querying and/or manipulation of the transaction database (K2Server) is not supported. With regards to the reporting database (K2ServerLog) querying of the data is not prohibited, but the actual editing of data is not supported.
+13John did you create those queries since K2 .NET 2003? If so did you need to make much changes to those queries migrating to BP?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.