Hi, I’m being hosted with godaddy.
They give me SQL server, the problem is that they dont give me access through Enterprise manager, only the hosting computer can access SQL server.
I’m trying to restore a Database backup, I already created the tables but now I have to import the data.
What would be the best way to do it?
Thanks in advance
about the first answer, well, I think I did not explained myself. I dont have access from my machine to SQL server. Only the webhosting computer has network access, but I dont have access to install applications, it is a shared hosting.
I only can run scripts against the database through code, so I thought maybe exporting to csv?
Install of MSDE will give you osql.exe on your machine. You may have osql access right now off of the server.
This is a command line interface that works much like Query Analyzer. From there you can restore the database using Restore command or really almost anything else.
Install of MSDE will give you osql.exe on your machine. You may have osql access right now off of the server.
This is a command line interface that works much like Query Analyzer. From there you can restore the database using Restore command or really almost anything else.
References :