How to run a SQL script
Posted on 2011-09-11
I've been developing VB6 apps for many years, and now I have to develop a VB10 (Visual Studio 2010) database app that is to be hosted on the web.
I've created the program, which connects to a local SQL Server database, and it runs ok
I've uploaded the code to a Fasthosts folder via FTP, and I've created a SQL Server database with Fasthosts, which has an IP address, user name and password
What I cannot figure out is how to upload the database schema and data to Fasthosts !!
VS 2010's Database Publishing Wizard let me create a .SQL script file, but how and where do I run it?
I'm sure this is fairly straightforward, but I can't find out what to do next
Grateful for any help