I'm trying to figure out the best way to move the development database to production. The development is on my home personal machine and production is on a hosting provider. I do have access to the production DB with microsoft sql server management studio.

Is it best to just export tables from development and drop them in production? Do I need to do all tables or just specific ones?

thanks

Nick

This didn't even answer my question. How do I move data from a development DB to a production DB on a hosting provider. I tried to export a table and got a Foreign Key Constraint Violation on the first table.

Someone please help me with this nightmare.

thanks

Nick

Thanks

I did do exactly that and my web hosting provider has done the restore. I copied the web.config from my local machine to the hosting provider and changed the connection strings.

When I try to open the website on the hosting provider, it actually does a redirect back to *localhost*.

What in the world is happening?

thanks

Nick