I'm using SQL Server 2008 management studio. Is it possible to generate 1 script from a database on localhost and run it on a production database? I'd like both the schema and data to be transfered to the online database.
How do I accomplish this task?