Monthly Archives: June 2011

crm test instance updates

ok after moving our crm test instance to a new destination (http://support.microsoft.com/kb/952934/en-us),  the next goal to reach was the update of this instance… not software, data…

our crm in the productiv environment is really used a lot… so to test (and develop) the actuall productiv data would be a big bonus… so we needed to copy the productiv database to the test environment. sounds easy… but it isnt…

so… first of all copying the database was easy… backup the data on the productiv sql server, restore it on the test sql server… voila… ok normally this works… but in crm we need to set the installation to the new database, with the same name, with actually no difference… but ok… and its easy, because a tool (Deployment Manager) on the test server can handle this… but because its the same name, crm thinks, it works already… and actually there is no refresh button in the deployment Manager… so just load a fake organisation… then load the correct organisation again… voila… but wait… its an actuall copy… so all absolute links are still pointing into the productiv environment (eg. isv.config) and funnyly relative links might be swiched by the crm to absolute… so crap…

ok currently we will do it manualy the updade, when we need it… if there is a way to automate the hole thing… contact me…

moving crm

we needed to move our crm environment… ok it sounds like bad idea and the reason was the server naming convention… ok now you will thick: why the hell didnt they do it correct the first time? actually… we did… but the consultant, how installed the crm, didnt… yeah and its our fault, that he did it wrong, we should have had controlled him better… but on the other hand, its just our test- / dev-enivornment… so it has no impact to our company, when we rename it, reinstall it and so on…

in my opinion, the move is not really importent… ok i am leaving this company next week, but its only a test server… therefore wth? but on the other side, we need to figure out a way, to replicate the data of the productiv environment to test… and i think this will actually be really similar to the move process… therfore, its training 🙂

and with following link pretty easy: http://support.microsoft.com/kb/952934/en-us

now i only have to re-install all our applications and re-configure the iis and re-register the plugins and… meh!

moving ms sql server

we needed to move an sql server… so we looked for space in our virtual environment… there was… but wth? moving is renaming… or isnt it? first it looked like it was, but secondly there were a few problems…

basiclly the sql server instance has the same name as the server… wrong!

sp_dropserver ‘old_name’
GO
sp_addserver ‘new_name’, local
GO

this statements change the instance name… following command returns the current instancename…

select @@SERVERNAME

and thats the history of renaming ms sql servers… funny…