Run SQL Scripts that create the tables, indeces, etc.

>I have a setup that we use to deploy on a new server whenever we have to do a new installation. This setup previously, among other things such as installing software, was also copying from our source server all the VFP free tables into the required production server directory. Now, those free tables are part of a SQL Server data structure. In order for us to ease the installation of a new server, what would be the best approach to setup the SQL Server data structure. Because, we can no longer use the COPY command to do all this.