I've been working on a production DB on a POS and Inventory System for over a year. That's over a year of data and along the way, I took that system and implemented to 4 locations and 4 individual servers. I've major software updates and Schema changes (adding Views, SP, changing Tables, etc.) By doing so, I can't keep up with all the changes and take the software from the main location with the DB changes and run that same software in the other locations. What I need is to export the changes w/o the data and import it to the other locations SQL Servers. How can I go about this??? Is it possible to take just the scheme of the DB and import it to an existing DB???
Please Help!!!