Never one to disappoint. Brian’s killer conference has come to a close. View the video below. For those of you involved in VDI/SBC this is a killer hard core conference you should add to your agenda for next year!
www.brianmadden.com

Shawn Bass is reporting some serious issues with the latest CSG build. Serious enough in fact that Citrix has pulled it from their site while they investigate. read about it here

http://bit.ly/CVmfa

For a recent project for a customer I had to migrate a xenapp farm from using an access datastore to SQL.  I have done this many times and the documentation is a bit sparse.  I decided to put together a couple of batch files to help with this. these could also be used as a base to move the datastore connection from one SQL Server to another.

The batch files in no way are meant to do it completely for you but will give you a starting point.  You will notice that throughout the files I do a dsmaint recreatelhc any time I change the DSN.

One interesting point to make.  When you copy the DSN from your one server to all of the local hosts prior to changing their config to start using it edit the file with notepad and change the line that starts with WSID, and referrences the name of the first server you created the DSN to the name of the current server you are working on. If you fail to do this when you look at connections in SQL Manager it will appear as though all the connections are coming from your first server.

I hope this saves someone some work. Comments welcome.

Files are provided with no warranties….

migrate-access2sql-Members.bat

migrate-access2sql-Datastore.bat