If your budget is restricted, you will not be able to enjoy the full TFS 2010 environment to deploy on an integration environment (VSTS 2010 Lab Management with a prerequisit of Hyper-V, powerfull servers, ...), you have at least the alternatives described below.
1/ By default, Visual Studio 2010 provides a transformation mecanism to deal with many versions of Web.Config (web.debug.config, web.release.config, ...) depending on the environment. However, if you want more than that (e.g. replace strings within App.Config), you will be able to do that for any XML configuration files, when using XML Document Transform (XDT) as described in :
2/ Use the default VS2010 "Package/Publish SQL" and "Package/Publish Web" in the Project's Property.
PS: With far less functionnalities that PowerGREP, but totally free and stable, you have Agent Ransack 2010 that is a file searching tool from Mythicsoft. It is a freeware 'lite' version of FileLocator Pro. However, you cannot replace text in files.
You could also add to your batch file a command to deploy your T-SQL scripts :
osql is a "old" command that comes with SQL Server.
Finally, create and call your batch file within your Build Definition, as long as you have extended it with a custom Workflow activity. For instance, Step 4 "Versionning" below does not exist be default,
and comes from a custom workflow activity.
More details on:
and the Best Practices here :