I've spent the last couple of days searching for tools that would help automate the task of copying SQL databases from one server to another(To be more accurate its the data in the database's that I ...

Read this chapter while sitting at your computer and try out the example shown. Before beginning, make sure you have access to the sample tables described. If you omit the username and password, ...