Visual Studio 2008

Mar 5, 2008 at 2:30 PM
Is it also possible to use the Microsoft Dynamics CRM 4.0 Performance Toolkit with Visual Studio 2008 and a enterprise SQL server 2005?
Coordinator
Mar 5, 2008 at 8:16 PM
Hi Ben - regarding vs 2008, we're looking into this now. Bottom line is it may require a little porting, and there may be new features we can take advantage of - but we're not expecting a big problem forward porting to 2k8. Feel free to give it a shot and let us know!

When you say enterprise SQL Sever 2005, are you referring to the load test database? If that's the case then yes, we use full blown SQL instances for our load test databases frequently (mainly because you can use up the 2GB MSDE database size limit pretty quick if you're making a bunch of big runs). You'll just need to patch up the connection strings in the config file. Post back if that's not clear, or you're talking about some other SQL role.

HTH,
Terry
Coordinator
Mar 6, 2008 at 12:45 AM
Edited Mar 6, 2008 at 12:46 AM
Hi Ben,
The Microsoft Dynamics CRM 4.0 Performance Toolkit currently uses the sql express installed by VSTS for EntityManager database during the MSI installation process. If you want to use enterprise SQL server 2005 to store the EntityManager database it is certainly possible but needs to be done after the MSI installation. In order to do that, you will need to create the EntityManager database in the Enterprise SQL 2005 by running EMDB_Setup.sql (located in ConfigFiles folder) and point the node "emsqlcnn" to point the correct database instance in ConfigSettings.xml file (located in the ConfigFiles folder).
The LoadTest database which is used by VSTS to store the Loadtest runs information resides in sqlexpress database by default. This also can be changed to Enterprise SQL server 2005. The MSI installation does not have a dependency on where Loadtest database exists. This can be done by clicking on Test -> Administer Test Controllers -> Load Test Results Store: and changing the Server name the appropriate sql server instance value.

Thanks,
Adi.