DB Schema Export/Import Help

Expand Post »

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!!!

Similar Threads

who outsources their work in IT Professionals' Lounge
export import active directory service in Windows NT / 2000 / XP
export import mysql in MySQL
Backing up a MySQL database in MySQL
moving public folders stumped in Windows NT / 2000 / XP

extofer

Reputation Points: 8

Solved Threads: 6

Posting Whiz in Training

Offline

239 posts
since Aug 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: Fast retrieving of records

Next Thread in MS SQL Forum Timeline: Unable to delete SQL records

DaniWeb Message

Cancel Changes

User Name
Password