(What I am showing the big red book of spanish verbs you will also work with VS 2008 with minor difference in the UI).
It allows a developer to deploy a local database from his development environment to a hosting provider on a remote system.Start Visual Studio 2010 and show Server Explorer.And yes, it means that you have this in VS 2010 as well.You can choose to qualify every object with the schema name.If you want to be selective, uncheck the option at the bottom of the page.Supply the necessary details including Instance name, Authentication details and the database and you are done.Once done, close the wizard.
The wizard creates a single script file which contains the schema and the data.This script file can be used to create an exact replica on the target system.In Server Explorer, connect to the database for which you want to create the script.For this example, let us script out in a file.Finally, you can choose to script out only the Data, or only the schema or both.(Be careful if you are scripting out a table with millions records.Let us interact on this one at the forums.You can choose to include the script for drop existing objects.
Browse and specify your file and then click Next.