On my SQL2005 Express DB, I created the scripts to create all the tables and stored procedures, to include the table data. I FTP'd them to a directory in my root folder at Winhost. How/where do I execute them so the tables and stored procs will be created? I do have MS Web Developer 2005 Express and SQL Server 2005 Management Studio Express.
For something like this I suggest you use the Restore/Backup tool inside the control panel. Its a little more efficient and much easier to use. The only thing is that you need to run a backup on your local database on your personal computer and get the .bak file. Make sure you drop any indexes on your database other wise the Restore tool may fail. You can recreate the Index once you have restore it on our SQL server. http://support.Winhost.com/KB/a771/how-do-i-generate-or-restore-a-backup-of-my-database.aspx
Where at Winhost can I execute a SQL script? Thank you for your help. I was able to restore my backup just like you said. You know your stuff. Thanks.
