Windows includes a SQL ODBC driver. If you are running Windows 2000, upgrade
to the latest version of MDAC.
Here is the general process to migrate:
1. Stop IMA on all servers.
2. Use ODBC Admin to create a file .dsn that points to the SQL database.
3. Run dsmaint migrate on your current Access data store server.
4. Run dsmaint config on the current Access data store server.
5. Start the IMA service on the current Access data store server.
6. Copy the .dsn to the other servers and run dsmaint config.
7. Restart the IMA service on the rest of the servers.
Most of this is basic SQL stuff. The only thing Citrix specific is the
dsmaint commands and stopping and starting of the IMA service.
-----Original Message-----
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On
Behalf Of Matt Kosht
Sent: Tuesday, January 02, 2007 8:12 AM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: Migrate Access datastore
How do I do that w/o SQL client to transport it?
On 1/2/07, Mike Semon <msemon@xxxxxxx> wrote:
> No, just make an ODBC connection.
>
> Mike
>
> -----Original Message-----
> From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx]On
> Behalf Of Matt Kosht
> Sent: Tuesday, January 02, 2007 7:58 AM
> To: thin@xxxxxxxxxxxxx
> Subject: [THIN] Re: Migrate Access datastore
>
>
> I read through this migration. I would need a SQL client installed on
> each Citrix server in the farm to communicate with the datastore SQL
> server correct?
> -Matt
>
> On 12/29/06, Joe Shonk <joe.shonk@xxxxxxxxx> wrote:
> > Look in the PS4 Admin guide (or is it the Advanced Admin Guide). Either
> > way, there are instructions on how to migrate the DS from Access to SQL
or
> > Oracle. It's fairly simple and for the most part can be done while
users
> > are still connected. No need to schedule an outage.
> >
> > Joe
> >
> > -----Original Message-----
> > From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On
> Behalf
> > Of Matt Kosht
> > Sent: Friday, December 29, 2006 9:58 AM
> > To: thin@xxxxxxxxxxxxx
> > Subject: [THIN] Migrate Access datastore
> >
> > Need to move off Access/Jet datastore hosted a XP 1.0 server in my
> > mixed farm (there are also PS 4.0 servers in the same farm/zone yes I
> > know that's not ideal) to a SQL Server elsewhere on the network. Any
> > tips on where to get started/pitfalls?
> > SBC SITES ONLY GOOGLE SEARCH: http://www.F1U.com
> > ************************************************
> > For Archives, RSS, to Unsubscribe, Subscribe or
> > set Digest or Vacation mode use the below link:
> > //www.freelists.org/list/thin
> > ************************************************
> >
> > SBC SITES ONLY GOOGLE SEARCH: http://www.F1U.com
> > ************************************************
> > For Archives, RSS, to Unsubscribe, Subscribe or
> > set Digest or Vacation mode use the below link:
> > //www.freelists.org/list/thin
> > ************************************************
> >
> SBC SITES ONLY GOOGLE SEARCH: http://www.F1U.com
> ************************************************
> For Archives, RSS, to Unsubscribe, Subscribe or
> set Digest or Vacation mode use the below link:
> //www.freelists.org/list/thin
> ************************************************
>
>
>
> SBC SITES ONLY GOOGLE SEARCH: http://www.F1U.com
> ************************************************
> For Archives, RSS, to Unsubscribe, Subscribe or
> set Digest or Vacation mode use the below link:
> //www.freelists.org/list/thin
> ************************************************
>
SBC SITES ONLY GOOGLE SEARCH: http://www.F1U.com
************************************************
For Archives, RSS, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
//www.freelists.org/list/thin
************************************************
