Solved

Access to SQL Data Store conversion

Posted on 2007-04-02
8
978 Views
Last Modified: 2012-06-21
Hello Experts~
Per a previous recommendation I am planning on moving our Access data store to a SQL server in our organization.  The SQL server (Server3) does not have any Citrix components installed on it.  The data store currently resides on Server1 (our initial Citrix server) which is also the License server.  Server2 is another PS4.0 server in the farm.  I'm planning to move the data store to Server3 (SQL Server), the License server to Server2 and eventually retire Server1 altogether.

Does Server3 need to have any Citrix components installed on it to permit it to host the data store for the farm?  I've read over a number of posts on converting an Access -> SQL data store but all seem to suggest stopping/starting services on the destination machine that doesn't have (currently) any Citrix-related components on it.

It's quite possible I'm misreading something but any help or suggestions would be appreciated.  Thank you.
0
Comment
Question by:MutleyFDI
  • 4
  • 3
8 Comments
 
LVL 10

Expert Comment

by:chrisnewman01
Comment Utility
SQL and Citrix are totally separate.  You do not need to have ANY Citrix components installed on the SQL server to convert a database from Access to SQL.  You pretty much have to run DSMAINT MIGRATE (Access credentials, then SQL credentials) on the command line, then run DSMAINT CONFIG (to tell Citrix to switch from the Access DB to the SQL server.  It's been a while since I've done it, but it's well documented here:  http://support.citrix.com/article/CTX677542&searchID=-1 (or simply Citrix Support article CTX677542)
0
 
LVL 19

Accepted Solution

by:
BLipman earned 125 total points
Comment Utility
DSMAINT MIGRATE  </SRCDSN:dsn1> </SRCUSER:user1> </SRCPWD:pwd1>
                 </DSTDSN:dsn2> </DSTUSER:user2> </DSTPWD:pwd2>
                 [/PATCHINDEX:1 to enable] [/RECREATEINDEX]

dsmaint migrate /srcdsn:"c:\program files\citrix\independant management architecture\mf20.dsn" /srcuser:citrix /srcpwd:citrix /dstdsn:"~~path to new dsn~~" /dstuser:~~NewLogin~~ /dstpwd:~~NewPwd~~

With an Access datastore the default username and password is citrix citrix respectively.  Make sure to enter the full absolute path to your DSN and put it in quotes; it will fail otherwise.  Make your database shell and user on the destination server and a DSN to point to this new DB.  Then your migrate command will copy and verify that the DS is moved.  
On this server and then each additional server you must do DSMAINT CONFIG to point to the new datastore, restart the IMA service after and all should be migrated.  You will need to configure your new DSN on each server but migrate only on the first.  
Check your current activity in SQL EM and make sure you see the new connections as you go.  I would suggest making your database and log file for your SQL database start off at ~30MB instead of the initial value so as to avoid any autogrow activity.  
0
 

Author Comment

by:MutleyFDI
Comment Utility
Thanks for the specifics on that.  Why doesn't the mf20.dsn appear in Data Sources (ODBC) from Adminitrative Tools?  The only DSN listed there (on both Servers) is IMADirectory which points to ..\imalhc.mdb.
0
 
LVL 19

Expert Comment

by:BLipman
Comment Utility
It is a file DSN, those only show up if you browse to them in your ODBC tool (unless they live in the default location).  
0
NetScaler Deployment Guides and Resources

Citrix NetScaler is certified to support many of the most commonly deployed enterprise applications. Deployment guides provide in-depth recommendations on configuring NetScaler to meet specific application requirements.

 

Author Comment

by:MutleyFDI
Comment Utility
Thanks for the clarification...I haven't used up my dumb questions quota yet, have I? :-)
Have created the new SQL db/dsn and will try the DSMAINT MIGRATE later tonight.  After the migration has occured and I run DSMAINT CONFIG I should be able to edit the MF20.dsn on each server and update them to point at the new db, is that correct?
Thanks for your continued help (and patience).
0
 

Author Comment

by:MutleyFDI
Comment Utility
Thanks again for the help. Both DSMAINT MIGRATE and CONFIG ran successfully. IMA restart and all seems well.
Do you know if the DSMAINT MIGRATE command would permit the /DSTDSN: parameter to be entered w/UNC format? I opted to create new MF20.dsn's on each of the resp. servers (keeping the /DSTDSN: parameters local) but wonder if the DSN I created on the SQL server could've been used (or not).
0
 
LVL 19

Expert Comment

by:BLipman
Comment Utility
I don't think that is a very good idea, simple networking issues could cause you some headaches whereas keeping it locally makes it available at all times.  I just copy the file from server to server.  When I do this I always keep my last DSN so there is a MF20.dsn and a MF20a.dsn.  The lowest letter is the most current DSN.  
0
 

Author Comment

by:MutleyFDI
Comment Utility
Good approach.  I thought there might be a hitch (or worse) referring to a remote DSN vs a local DSN...thanks for confirming!
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Citrix XenApp, Internet Explorer 11 set to Enterprise Mode and using central hosted sites.xml file.
CITRIX XENAPP 6.5 FARM CUSTOM POLICY - CHANGE MANAGEMENT WINDOW REBOOT SCHEDULE
How to install and configure Citrix XenApp 6.5 - Part 1. In this video tutorial we have explained step by step installation of Citrix XenApp 6.5 Server on Windows Server 2008 R2 is explained in this video. We have explained the difference between…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now