Sql Server Hosting Godaddy
SQL Server Enterprise Manager?
Hi, I'm hosted with GoDaddy. They give me the SQL server, the problem is that I dont give access through the representation Manager, only the computer that hosts can access the SQL server. I am trying to restore a backup database, I've created the tables, but now I have to import the data. What the best way to do it? Thanks in advance for the first answer, well, do not think I explained. I can not access my machine from the SQL server. Only webhosting computer has network access but have no access to install applications, this is a shared hosting. I can only run scripts against the database through the code, so I thought maybe export to CSV?
Osql.exe will install MSDE on your computer. You can access osql now out of the server. It is a command line interface that works like Query Analyzer. From there you can restore the database with the restoration command, or indeed almost any other.