I am attempting to transfer a database from my local SQL Server to my ISP's
SQL Server. I can transfer a database internally, I can transfer a
database FROM my ISP to my local machine, but I cannot transfer from my
local machine TO my ISP's machine.
I am using the transfer utility in the Enterprise Manager to perform the
transfer. I can do the transfer, and it even comes back telling me the
transfer completed successfully. However, the tables are NOT transfered.
There are no errors in the logs.
Here's where things get a little strange. I have looked at the script
files, namely the .tab file. I have looked at the SQL code, and if I use
ISQL_w on their server, and run the SQL code manually, it creates the table
just fine. It's only when it's run from the script that it doesn't work.
Suggestions? Please be detailed. I have been thrown into this SQL Server
world rather abruptly, and I'm drowning a little (I've only been doing DBA
for about a week now.) I understand most of the concepts, but have not had
much practice. I do have a strong networking background (I'm actually a
network administrator), but most of this is new. So, no minor detail is
too small to mention.
Thanks in advance for any assistance,
Jason W. Pegg