Running SQL scripts from a batch file
Posted on 2008-06-10
New to SQL Server 2005. I'm wanting to batch upload data from a remote system (VMS) into a SQL Server 2005 database. I've scripted out into files, the commands I need to create the table(s), insert the data, and then to drop the tables. I'm able to run the commands manually, can anyone share with me information on how to put these commands into a .bat file that I can run via the scheduler.
Also...is there a wait to script out the commands needed to create the Full-Text Indexes I need for these tables. I didn't see how to do this in the SQL Server Management Studio.