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

  • From: ecrabtree@xxxxxxxxxxxx
  • To: thin@xxxxxxxxxxxxx
  • Date: Thu, 13 Mar 2003 07:47:49 -0500


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

Other related posts: