[THIN] Re: Moving Datastore to SQL
- From: "Mike Semon" <msemon@xxxxxxx>
- To: <thin@xxxxxxxxxxxxx>
- Date: Thu, 16 Jun 2005 16:16:11 -0500
David,
It is in the Advanced Concept Guide CTX 677542,
To migrate from Access to Microsoft SQL Server or Oracle
Note: Migration from an Access indirect database to a Microsoft SQL Server
2000 direct database using the dsmaint migrate command is supported only
with MDAC 2.5.
1.. 1. Create a new database on Oracle or Microsoft SQL server.
2.. 2. Create a new Mf20.dsn file pointing to the new database created in
Step 1. By default, the DSN file is located in the following directory:
%ProgramFiles%\Citrix\Independent Management Architecture.
3.. 3. On the host server, execute the dsmaint migrate command, entering
the current DSN file as the source and the new DSN file created in Step 2 as
the destination. If the password for the old database is not changed, the
default user name/password is citrix/citrix.
Tip: Enter the complete path (inside quotation marks if the path contains
spaces) of the DSN file when required as a parameter for the dsmaint migrate
command.
1.. 4. Execute dsmaint config on the original host server to point to the
new DSN file.
2.. 5. Stop and restart the IMA service on the host server. When the IMA
service on the host server is restarted, the remaining indirect servers
begin accessing the new data store indirectly through the host server.
Important: Restarting the IMA service instead of restarting the server might
cause the SNMP service to Dr. Watson if SNMP is enabled. This error is
benign.
1.. 6. Copy the DSN file created in Step 2 to all remaining indirect
servers in the farm.
2.. 7. Execute dsmaint config on all remaining indirect servers to
establish a direct connection to the new database through the DSN copied in
Step 6.
3.. 8. Stop and restart the IMA service on all remaining indirect servers
in the farm.
Tip: You can execute Steps 6 through 8 on all the servers from a simple
batch file placed in a central location.
Hope that helps,
Mike
-----Original Message-----
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx]On Behalf
Of David Teague
Sent: Thursday, June 16, 2005 3:19 PM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Moving Datastore to SQL
I used to have the instructions on the steps to move from the jet database
's to the sql datastore, but I do not, and I cannot find them in the Citrix
knowledge base, any one have a link for this procedure handy?
David Teague
Support Analyst
TMTsoftware
919-493-4700
Other related posts:
