I have seen this discussed all over the place, but no answers. Maybe I can get one here.
Best way to present this question is with a scenario:-
I have a Development Database, and a Production Database. My client needs a new feature on their website, which requires a new table. Once i have developed the new feature and completed testing I am ready to go live. To do this I upload the new and modified files to the webserver, and export the new table to the production database. Simple. I've been doing it for years.
The thing is, it is simple in SQL Server 2000 Enterprise Manager, but seems impossible in SQL Server 2008 Management Studio. I can export a table, but None of the indexes, triggers or data go across.
So, the question is, using SQL Server 2008 Management Studio, what is the best way to get a table (includeing all triggers, indexes and data) from one database to another?
Many Thanks in advance. Whoever can help me solve this will be my hero for life!!