How can I transfer SQL Server data between an Intel box and an Alpha?

A. With 6.5 and below you cannot use the DUMP and LOAD DATABASE commands - it does not do the necessary byte re-ordering to make this work. Therefore you must use bcp, DTS, the transfer tools supplied in SQL EM or write your own ODBC/DMO based applet.

With SQL 7.0 the byte re-ordering is done for you and so dumps and loads across architectures are supported.


Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish