I've worked for some time with Oracle. To script our tables (creation, default data,...) we had serveral sql files (one for each creation and filling of each table). We had one "master sql file" that called all those files. It was very easy with our sqlplus command line tool to connect to the database, type the name of the master script file, and then all required other scripts were called to configure our database and tables. Now, client asks to port our application to sql server 2005, and i am new with that. What is the way of working in such a case? (in sql server 2005 i've worked with querry analyser, but it would be a lot of work to open and execute each script).