[THIN] Re: Migrating Data Store question
- From: "Jim Hathaway" <JimH@xxxxxxxxxxxxxxx>
- To: <thin@xxxxxxxxxxxxx>
- Date: Thu, 4 Dec 2003 12:09:04 -0800
The MF Admin guides are a good reference on the best ways to setup your
SQL DB, so I won't go it that here. You can get the latest guides for
your MF version from here:
http://support.citrix.com/kb/entry.jspa?entryID=168&categoryID=119
(check page 40)
Once that's done however. You can use ODBC from one of your servers to
create a new *.dsn file to your new SQL DB. After the file is created,
edit it with notepad, make sure that it's entries look similar to the
following:
[ODBC]
DRIVER=SQL Server
UID=IMA
Network=DBNMPNTW
DATABASE=%your IMA DB name%
WSID=%your current server's name%
APP=Microsoft Open Database Connectivity
SERVER=%your SQL server's name%
Description=Citrix
On your server that currently hosts your Access IMA DB, run the
following to migrate all IMA data to your new store:
dsmaint migrate /srcdsn:"M:\Program Files\Citrix\Independent Management
Architecture\mf20.dsn" /srcuser:citrix /srcpwd:citrix
/dstdsn:"M:\Program Files\Citrix\Independent Management
Architecture\Citrix.dsn" /dstuser:(username) /dstpwd:(password)
(note - the srcuser, and srcpwd values are "Citrix" by default. The
dstuser, and dstpwd are the user name and password values to connect to
your SQL DB.)
Once it's successfully migrated the DB, you'll need to make updates to
all the rest of the servers in your farm. A common trick to ensure each
server is moved properly, is to create a new published app in the farm
from a server that has been moved to the SQL DB. As you move each new
server, make sure they display the new pub app, when logging on to them
locally through the CMC.
You can use the following script (*.bat) to migrate the rest of your
servers.
@echo off
echo.
echo.
echo Set the servers' ima to look at the new DSN
dsmaint config /user:(username) /pwd:(password) /dsn:"M:\program
files\Citrix\Independent Management Architecture\Umpqua.dsn"
echo.
pause
net stop imaservice
echo.
pause
net start imaservice
echo.
Pause
Obviously you'll need to change the script pathing if your TS system
drive letters are other than M:\.
HTH
J
-----Original Message-----
From: Jeff Durbin [mailto:techlists@xxxxxxxxxxxxx]
Sent: Thursday, December 04, 2003 11:34 AM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: Migrating Data Store question
I thought I had done this and documented it, but it turned out that I
had
moved the datastore from one SQL server to another. I have that if
anyone's
interested.
Jeff Durbin
-----Original Message-----
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On
Behalf
Of Brian Delaney
Sent: 5 December 2003 2:27 AM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Migrating Data Store question
I have win2k sp4 XP Metaframe FR2
We have installed a SQL server and i'd like to move my data store from
the
current serve based access database to the new sql server. Looking for a
good resource that explains how to do this.
Thanks
*
*
*
This message, including any attachments, is intended solely for the use
of
the named recipient(s) and may contain confidential and/or priveleged
information. Any unauthorized review, use, disclosure or distribution
of
this communication(s) is expressly prohibited. If you are not the
intended
recipient, please contact the sender by reply e-mail and destroy any and
all
copies of the original message.
********************************************************
This Week's Sponsor - ThinPrint .Print Server Engine
Thinprint can help you save money, protect resources,
simplify administration, save time and increase
flexibility by solving all of your printing needs.
http://www.thinprint.com
**********************************************************
Useful Thin Client Computing Links are available at:
http://thethin.net/links.cfm Domains currently for sale by The Kenzig
Group
http://www.kenzig.com/serv01.htm New Site: Free Weblogs!
http://www.blogvortex.com
***********************************************************
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
http://thethin.net/citrixlist.cfm
********************************************************
This Week's Sponsor - ThinPrint .Print Server Engine
Thinprint can help you save money, protect resources,
simplify administration, save time and increase
flexibility by solving all of your printing needs.
http://www.thinprint.com
**********************************************************
Useful Thin Client Computing Links are available at:
http://thethin.net/links.cfm
Domains currently for sale by The Kenzig Group
http://www.kenzig.com/serv01.htm
New Site: Free Weblogs!
http://www.blogvortex.com
***********************************************************
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
http://thethin.net/citrixlist.cfm
********************************************************
This Week's Sponsor - ThinPrint .Print Server Engine
Thinprint can help you save money, protect resources,
simplify administration, save time and increase
flexibility by solving all of your printing needs.
http://www.thinprint.com
**********************************************************
Useful Thin Client Computing Links are available at:
http://thethin.net/links.cfm
Domains currently for sale by The Kenzig Group
http://www.kenzig.com/serv01.htm
New Site: Free Weblogs!
http://www.blogvortex.com
***********************************************************
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
http://thethin.net/citrixlist.cfm
Other related posts:
