Advertisement

08.09.2005 at 05:31AM PDT, ID: 21520601
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

Moving Data Store to New Server
Zone: Citrix
Tags: citrix, data, store, move
I have purchased a dedictaed SQL server and want to migrate the data store to this server.

The server will not have Citrix installed or indeed be part of the Farm.

What is the best way of doing this and how do i point the servers that are in the Farm at the datastore?
Start your free trial to view this solution
Question Stats
Zone: Networking
Question Asked By: Avatar261
Solution Provided By: darrengp
Participating Experts: 2
Solution Grade: A
Views: 314
Translate:
Loading Advertisement...
08.09.2005 at 08:43AM PDT, ID: 14633748

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
08.09.2005 at 08:45AM PDT, ID: 14633765

Rank: Master

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
08.09.2005 at 08:45AM PDT, ID: 14633774

Rank: Master

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
08.09.2005 at 08:48AM PDT, ID: 14633801

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
08.09.2005 at 08:49AM PDT, ID: 14633809

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
08.09.2005 at 08:51AM PDT, ID: 14633832

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
08.09.2005 at 08:56AM PDT, ID: 14633884

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
08.09.2005 at 08:58AM PDT, ID: 14633903

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
08.09.2005 at 09:02AM PDT, ID: 14633958

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
08.10.2005 at 01:17AM PDT, ID: 14639790

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
08.10.2005 at 01:20AM PDT, ID: 14639803

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
08.10.2005 at 03:46AM PDT, ID: 14640459

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
08.10.2005 at 04:03AM PDT, ID: 14640547

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
08.10.2005 at 04:04AM PDT, ID: 14640550

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
Microsoft
  • Internet Protocols
  • Applications
  • Development
  • OS
  • Hardware
  • Windows Security
Apple
  • Operating Systems
  • Hardware
  • Programming
  • Networking
  • Software
Internet
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Spy / Ad Blockers
  • Web Browsers
  • New Net Users
  • Web Development
  • Chat / IM
  • Anti Spam
  • Web Servers
  • Anti-Virus
  • Email Clients
Gamers
  • Tips
  • Online / MMORPG
  • Puzzle
  • Emulators
  • Action / Adventure
  • Role Playing
  • Consoles
  • Game Programming
  • Strategy
  • Sports
  • Misc
  • Computer Games
Digital Living
  • Hardware
  • New Net Users
  • New Users
  • Software
  • Digital Music
  • Gaming World
  • Home Security
  • Apple
  • Networking Hardware
Virus & Spyware
  • Vulnerabilities
  • IDS
  • Encryption
  • Anti-Virus
  • Operating Systems Security
  • Software Firewalls
  • WebApplications
  • Cell Phones
  • Operating Systems
  • Internet
  • Hardware Firewalls
Hardware
  • Handhelds / PDAs
  • Displays / Monitors
  • Components
  • Networking Hardware
  • Peripherals
  • Laptops/Notebooks
  • Storage
  • Servers
  • Desktops
  • New Users
  • Misc
  • Apple
Software
  • System Utilities
  • Industry Specific
  • Network Management
  • Photos / Graphics
  • Page Layout
  • VMWare
  • Misc
  • Web Development
  • OS
  • CYGWIN
  • Voice Recognition
  • Message Queue
  • Quality Assurance
  • Security
  • Firewalls
  • MultiMedia Applications
  • Development
  • Database
  • Office / Productivity
  • Business Management
  • OS/2 Apps
  • Server Software
  • Internet / Email
ITPro
  • OS
  • Storage
  • Encryption
  • Operating Systems Security
  • Apple Hardware
  • Laptops & Notebooks
  • Servers
  • Networking Hardware
  • Peripherals
  • Devices
  • Displays / Monitors
  • WebTrends / Stats
  • Search Engines
  • Firewalls
  • WebApplications
  • IDS
  • Vulnerabilities
  • Email Clients
  • File Sharing
  • Spy / Ad Blockers
  • Web Browsers
  • Web Servers
  • Networking
  • Anti-Virus
  • Chat / IM
  • Anti Spam
Developer
  • Web Servers
  • Web Browsers
  • Game Programming
  • Dev Tools
  • Industry Specific
  • Office / Productivity
  • Database
  • CYGWIN
  • Web Development
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Programming
  • Content Management
  • Application Servers
  • Protocols
Storage
  • Removable Backup Media
  • Storage Technology
  • Servers
  • Grid
  • Remote Access
  • Backup / Restore
  • Misc
  • Hard Drives
OS
  • Miscellaneous
  • Security
  • Development
  • Linux
  • VMWare
  • MainFrame OS
  • Unix
  • Apple
  • OS / 2
  • AS / 400
  • BeOS
  • Microsoft
  • VMS / OpenVMS
Database
  • Oracle
  • Miscellaneous
  • MySQL
  • Software
  • Sybase
  • Contact Management
  • PostgreSQL
  • Data Manipulation
  • Clarion
  • InterSystems Cache
  • Siebel
  • MUMPS
  • OLAP
  • SQLBase
  • SAS
  • GIS & GPS
  • 4GL
  • Berkeley DB
  • DB2
  • Informix
  • Interbase / Firebird
  • FoxPro
  • Reporting
  • LDAP
  • Filemaker Pro
  • MS SQL Server
  • dBase
  • MS Access
Security
  • Misc
  • Web Browsers
  • Software Firewalls
  • Operating Systems Security
  • File Sharing
  • Spy / Ad Blockers
  • Vulnerabilities
  • WebApplications
  • IDS
  • Anti-Virus
  • Encryption
  • Anti Spam
  • Email Clients
  • VPN
  • Chat / IM
Programming
  • Editors IDEs
  • Installation
  • Handhelds / PDAs
  • Multimedia Programming
  • System / Kernel
  • Algorithms
  • Game
  • Signal Processing
  • Project Management
  • Open Source
  • Database
  • Misc
  • Languages
  • Processor Platforms
  • Theory
Web Development
  • Scripting
  • Blogs
  • Web Servers
  • Software
  • Search Engines
  • Web Graphics
  • Images
  • Internet Marketing
  • Images and Photos
  • Components
  • Document Imaging
  • Web Languages/Standards
  • Illustration
  • WebApplications
  • Fonts
  • WebTrends / Stats
  • Authoring
  • Digital Camera Software
  • Miscellaneous
Networking
  • Protocols
  • Apple Networking
  • Network Management
  • Message Queue
  • Application Servers
  • Content Management
  • File Servers
  • Email Servers
  • Misc
  • Java Editors & IDEs
  • Wireless
  • Networking Hardware
  • Backup / Restore
  • System Utilities
  • ISPs & Hosting
  • Web Servers
  • Storage Technology
  • Removable Backup Media
  • Servers
  • Broadband
  • Grid
  • OS / 2
  • Novell Netware
  • Unix Networking
  • Windows Networking
  • Security
  • Telecommunications
  • Operating Systems
  • Linux Networking
Other
  • Community Advisor
  • Lounge
  • Community Support
  • New Net Users
  • Philosophy / Religion
  • Math / Science
  • Miscellaneous
  • URLs
  • Expert Lounge
  • Politics
  • Puzzles / Riddles
Community Support
  • Suggestions
  • New to EE
  • New Topics
  • Community Advisor
  • CleanUp
  • Announcements
  • General
  • Feedback
  • Input
  • EE Bugs
 
08.09.2005 at 08:43AM PDT, ID: 14633748
you need to run the dsmaint utility

http://www.thin-world.com/MFCommands/dsmaint.htm


should give you all the info you need let me know if I can help more

Darren
 
08.09.2005 at 08:45AM PDT, ID: 14633765

Rank: Master

You should be done in no time, this is a fairly common need.

This is an excerpt from http://www.citrix4ge.de/ctxsffaq/index.htm#dsmig

If you go to this link, scroll down to 31

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

  Create a new SQL Database on the SQL Server ("sa" as user)
Create DSN file on the citrix server for the SQL Database and save it to
"%ProgramFiles%\Citrix\Independent Management Architecture" let's
say as SQL.DSN
Open command line and run DSMAINT

dsmaint migrate /srcdsn:"%ProgramFiles%\Citrix\Independent Management Architecture\MF20.dsn" /srcuser:citrix /srcpwd:citrix /dstdsn:"%ProgramFiles%\Citrix\Independent Management Architecture\SQL.DSN" /dstuser:sa /dstpwd:

on every other server in the farm copy the SQL.DSN to the server and run

dsmaint config /user:sa /pwd: /dsn:"%ProgramFiles%\Citrix\Independent Management Architecture\SQL.DSN"
MetaFrame XP Advanced Concepts - Farm Maintenance
CTX677542
Advanced Concepts Guide for MetaFrame XP FR3
CTX102497
Migrating a MetaFrame XP Access Database to Oracle 9i
CTX102551
 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 
08.09.2005 at 08:45AM PDT, ID: 14633774

Rank: Master

Darren...didn't mean to step on your toes there.
 
08.09.2005 at 08:48AM PDT, ID: 14633801
no worries we were posting at the same time :)

don't forget on each server to run dsmaint reacreatelhc or you could get false alerts for can't connect to datastore (must stop ima service to run)

 
08.09.2005 at 08:49AM PDT, ID: 14633809
does it matter though that the new SQL server will not have Citrix installed?
 
08.09.2005 at 08:51AM PDT, ID: 14633832
no not at all best not to I have found
 
08.09.2005 at 08:56AM PDT, ID: 14633884
after i have migrated the DSN to SQL.DSN and run the config on the other servers, how do the servers then know to look at the new SQL server for the datastore?

or do i specify in the new SQL DSN the server name?
 
08.09.2005 at 08:58AM PDT, ID: 14633903
the dsmaint config (.dsn file) will have the new database in
 
08.09.2005 at 09:02AM PDT, ID: 14633958
hmmm i dont quite follow, surely you have to tell it somewhere where the new SQL server is?
 
08.10.2005 at 01:17AM PDT, ID: 14639790
when you create the new .dsn file or alter the existing you put the details of the new sql server along with the username and password information.
Do you require details on creating the dsn?

Darren
 
08.10.2005 at 01:20AM PDT, ID: 14639803
please, if thats ok with you
 
08.10.2005 at 03:46AM PDT, ID: 14640459
You there Darren?
 
08.10.2005 at 04:03AM PDT, ID: 14640547
yep sorry

admin tools
data sources (odbc)
select file dsn
browse to where you existing metaframe dsn is (default is program files     then citrix    then indepentdent management architecture
hightlight the dsn click configure
select the server
click though and ensure you have the correct username and password and correct database selected

then use the dsmaint config command on each server

dsmaint config /user:username /pwd:password /dsn:complete path including file name

then run dsmaint recreatelhc on each server to resync the local host cache

hope this makes sense

Darren
Accepted Solution
 
08.10.2005 at 04:04AM PDT, ID: 14640550
you can copy the dsn file to each server after you create / change it on the first one
 
 
20080236-EE-VQP-29