[THIN] Re: White Papers on new support site Citrix

  • From: Jan Homan <Jan@xxxxxxxxxx>
  • To: "'thin@xxxxxxxxxxxxx'" <thin@xxxxxxxxxxxxx>
  • Date: Thu, 13 Mar 2003 14:12:21 +0100


Thanks but I need the whole article.

-----Oorspronkelijk bericht-----
Van: ecrabtree@xxxxxxxxxxxx [mailto:ecrabtree@xxxxxxxxxxxx]
Verzonden: Thursday, March 13, 2003 1:48 PM
Aan: thin@xxxxxxxxxxxxx
Onderwerp: [THIN] Re: White Papers on new support site Citrix




From Document ID: CTX677542)

An alternative method for migrating between databases having the same
version is to use the export/import process instead of a backup and
restore process. Microsoft SQL Server 7 uses OLE for the export/import
functions, which truncates any binary data greater than 256 bytes. As
such, using export/import on Microsoft SQL Server requires that the
following steps replace Step 1 above:

1. Export data from the original (source) database and import data
into the new (destination) database using the standard export/import
procedures described in the database vendor's documentation.

2. In the destination database, delete the table DATATABLE. This table
contains the truncated data as described above.

3. Execute the following SQL command in the destination database
context to recreate the DATATABLE table with non-truncated data:

SELECT * INTO DATATABLE FROM
[SourceServerName].[SourceDBName].dbo.DATATABLE;

NOTE: The brackets in the above SQL command are required if the name
contains a space or special character. Also, the source server must be
registered with the new database server as a linked server and must be
running when the above SQL command is executed.

4. Recreate the following indexes on DATATABLE: DATATABLEINDEX cluster
index on nodeid DATACONSISTENT unique index on (nodeid and partno)

NOTE: You can recreate the index by choosing Run a Wizard > Database >
Create Index Wizard from the Enterprise Manager Console.

5. Follow Steps 2 through 8 above to complete the database migration
process.




This communication may contain information that is legally privileged,
confidential, or exempt from disclosure.  If you are not the intended
recipient, please note that any dissemination, distribution, or copying is
strictly prohibited.  If you have received this message in error please
notify the sender by telephone, fax, or return email and delete this message
from your computer.  Thank you.

*********************************************************
This Week's Sponsor - RTO Software / TScale
TScale increases terminal server capacity. 
Get 30-40% more users per server to save $$$ and time. 
Add users now! - not more servers. If you're using Citrix, 
you must learn about TScale!  Free 30-day eval:
http://www.rtosoft.com/Enter.asp?ID=79
**********************************************************

For Archives, to Unsubscribe, Subscribe or 
set Digest or Vacation mode use the below link:
http://thethin.net/citrixlist.cfm
*********************************************************
This Week's Sponsor - RTO Software / TScale
TScale increases terminal server capacity. 
Get 30-40% more users per server to save $$$ and time. 
Add users now! - not more servers. If you're using Citrix, 
you must learn about TScale!  Free 30-day eval:
http://www.rtosoft.com/Enter.asp?ID=79
**********************************************************

For Archives, to Unsubscribe, Subscribe or 
set Digest or Vacation mode use the below link:
http://thethin.net/citrixlist.cfm

Other related posts: