Hello all,

Hope I explain this correctly. i'm developing a ASP.NET web app for a client.
This web app, once it's uploaded to webserver, will use a SQL 2005 DB for its data, membership, roles, etc.

But in the meantime I have a separate site which I upload the client's site to for approval by that client before posting to production. For local development on my laptop I use database files (.mdf) in the App_data folder and upload that to my client approval site.

My question is this: once I'm ready to upload the web app and data to my production server I'll want to transfer all the objects (tables, queries, stored procedures, etc.) from the database file (.mdf) to my SQL 2005 DB. Sounds like a simple SSIS package to transfer the objects will from the database file to the SQL 2005 DB would work great. But when using SSIS, it only lets me connect to servers to retrieve objects from databases and not database files. I'm hoping there's a way to be able to do this cause I'd like to be able to build web apps that use database files and transfer the objects to production servers when I'm ready. If anyone could assist with how I would go about transferring objects from database files (.mdf) to SQL DBs and vice versa that would be great!

Thanks,

Strick