Copying data from one table to another in SQL Server

Hi,

I have two tables: 'Master' and 'Maximo'. I need to populate the sub-tables in 'Master' with the data from the equivalent sub-tables in 'Maximo'.

I'm aware that I can do this for each individual sub-table by using the Insert and Into commands and specifying the fields to populate.

However, there are 300 sub-tables which need to be populated.

Is there a batch command in SQL that would allow the easy migration of data from one table into another? The field structure is the same on both, so that should not be an issue.

I'm using Windows 2000 terminal to access the server with the databases on it. SQL Server 2000 and using MS SQL Server Enterprise manager.

Apologies if this is a really dumb question. I'm not very familiar with SQL and have rather been thrown in at the deep end with this.

Thanks in advance.Only thing i can suggest is create a dts using code such as:

"insert into <tablename>
select * from <tablename>"

once created you can re run the dts as many times as you like.|||Thanks for the suggestion. I'll give it a go.