Citrix Move Access Datastore to SQL 2000

Posted on 2007-07-27
Last Modified: 2012-05-05
I have a 2 server (server1 and server2) Citrix PS 4.0 farm.  The datastore is an Access database located on server1.  How do I move the datastore to SQL 2000 on another server (server3)?
Question by:zabac
    LVL 19

    Expert Comment

    You want to use the DSMAINT command from one of the Citrix servers.  
    --DSMAINT MIGRATE HELP, execute that and follow the instructions.  Essentially, you want a db on the SQL server and a user who has db_owner on just that database.  Set up a DSN on the citrix server to point to the DB with those user cred.s (make this a File DSN and save it in the c:\Program Files\Citrix\Independent Management Architecture folder).  The DSMAINT command needs a source DSN and a target DSN.  The source DSN is mf20.dsn (it sits in the IMA folder); you will need to use Citrix as the username and citrix as the password (default for access datastores).  This command will pop up a GUI progress bar and tell you if thigs transfer.
    Then, set up a DSN to the new database on your second server.  Specify this in a DSMAINT CONFIG command (use HELP again for syntax, not /? here, won't work).  Bounce the IMA service on each server after their respective commands finish and check the new SQL database for a connection from each server (refresh Current Activity in Enterprise Manager).  
    LVL 19

    Expert Comment

    LVL 8

    Accepted Solution

    Hi zabac,

    I would go to Microsoft website and download the new Microsoft SQL server 2005 Express Edition SP2 and install it on one of your Citrix server.
    Then use the tools in the Citrix Presentation server CD-Rom to migrate the Access database to SQL Server 2005 Express edition.

    The Citrix Presntation Server 4.5 CD has a utility called Migratetosqlexpress.exe that odes this for you. I don't remember if the Presentation server 4.0 has the same utility or not.


    LVL 8

    Expert Comment

    You may want to look inside the support folder in your Citrix Cd. It might have a similiar tool for migrating the access database to Microsoft SQL 2000 MSDB databse.

    LVL 5

    Expert Comment


    Find out the below link, it will very helpful to migrate the access to sql

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    #Citrix #Internet Explorer #Enterprise Mode #IE 11 #IE 8
    Citrix XenDesktop 7.6 Citrix Policies Graphics
    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.

    745 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

    14 Experts available now in Live!

    Get 1:1 Help Now