I'm not sure if I should be asking this here or over at stackoverflow I apologize if it is the latter.
I have been developing an application in Visual Studio 2010 and using it's built in database functionality with a local .mdf file. I have recently gotten access to a SQL Server 2008 installation, but I can't figure out how to migrate the database.
I have gotten Visual Studio to create a SQL script that should migrate the data, but I can't figure out how to actually run it in SQL Server Management Studio.
Any ideas? Ideally I would like to migrate the schema and the data, but I can settle for just the schema.