I've got a table I'd like to move from NT to the Unix version of texis. Trouble is, I can't get the syntax of copydb correct.
the remote server's name is vortex1, and the remove database is e:\database\mydb. The table in question is called "mytable"
I only want to copy "mytable" to the unix database (located in /db03/databases/newdb), and not the whole e:\database\mydb database itself. Could someone show me the syntax to pull that off?
Oh, and if you could do one more thing-- in case I can't get copydb to work for me, I'll just write out the table to a carat delimited text file. Trouble is, I've forgotten how to do that with the tsql command. I thought it was something like:
tsql -hq"^" "select * from mytable"
but that doesn't seem to work. Again, if you could correct my faulty memory I'd be grateful.
the remote server's name is vortex1, and the remove database is e:\database\mydb. The table in question is called "mytable"
I only want to copy "mytable" to the unix database (located in /db03/databases/newdb), and not the whole e:\database\mydb database itself. Could someone show me the syntax to pull that off?
Oh, and if you could do one more thing-- in case I can't get copydb to work for me, I'll just write out the table to a carat delimited text file. Trouble is, I've forgotten how to do that with the tsql command. I thought it was something like:
tsql -hq"^" "select * from mytable"
but that doesn't seem to work. Again, if you could correct my faulty memory I'd be grateful.