zabac
asked on
Citrix Move Access Datastore to SQL 2000
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)?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
Nitadmin
Nitadmin
Hi,
Find out the below link, it will very helpful to migrate the access to sql
http://www.dabcc.com/article.aspx?id=9882
Find out the below link, it will very helpful to migrate the access to sql
http://www.dabcc.com/article.aspx?id=9882
--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).