Tools that I have: SQL Server Database/SSIS/SSAS/SSRS Different servers for Dev/Stage/Prod Different DB for Dev/Stage/Prod (SSMS/SSAS)
Goal: Create something in dev environment. Pass it to Staging. After verification, pass it to production.
Question: How do I do that?
once I make some tables, packages, cubes, packages in dev, how do i push it to staging server and finally production server?
You don't specify the version you're using, so I'll just assume something other than 2012. The information below applies to versions 2005, 2008, or 2008 R2.
For SSIS - see this:http://technet.microsoft.com/en-us/library/cc966389.aspx. Short story- there is a package deployment utility that you use in BIDS that can use to put together a manifest that allows an admin to push all your packages to a target location, either on the file system or in MSDB.
For SSRS - see this: http://rsbuild.codeplex.com/ for a tool that you can use to deploy reports. You can also write an RSS script to give to an admin with your RDL files to deploy. You can learn more about this and other options at : http://www.sqlservercentral.com/articles/Administration/2967/
For SSAS - there is a deployment wizard you open from the Analysis Services folder in the Microsoft SQL Server 20xx program group (from the Start menu). You point it to an ASDATABASE file and step through the wizard to configure any settings you want (like changed connection strings) and produce an XMLA script file that you can hand off to an admin for execution on the target server. Learn more here: http://msdn.microsoft.com/en-us/library/ms174817.aspx