Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlserverdba
Yak Posting Veteran
53 Posts |
 Posted - 2009-05-01 : 11:17:07
|
| Hi,I'm running sqlserver2005.I've production and development servers.I want to refresh development server.The problem is I've few objects in development which doen't exist in production. I want to preserve those objects.The pbjects are 6 tables,3 procedures,one schema, and 2 users in Development.Please advice which method would be good. Does export/import works?Thanks |
|
|
sqlserverdba
Yak Posting Veteran
53 Posts |
Posted - 2009-05-01 : 14:16:10
|
| Any idea team? |
 |
|
|
ddamico
Yak Posting Veteran
76 Posts |
Posted - 2009-05-01 : 15:29:27
|
| Our company uses software from a compny called RedGate. They have a bundle of tools that can be used to do various tasks in the dataase.1. Compare two databases and automatically generate the scripts to makes changes to objects in different environments.2. Data Compare - This tool can be used to create scripts that will reproduce data that you want to replicate in another database.They have trial versions. Honestly we only use the object compare and not data. I have used both in trial and they work wonderfully. |
|
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-05-02 : 02:44:32
|
quote:
Originally posted by sqlserverdba
Hi,I'm running sqlserver2005.I've production and development servers.I want to refresh development server.The problem is I've few objects in development which doen't exist in production. I want to preserve those objects.The pbjects are 6 tables,3 procedures,one schema, and 2 users in Development.Please advice which method would be good. Does export/import works?Thanks
u can script out these objects and copy them into a new database on development server if u know exactly wht the objects are, other wise u definitely need to have some objects compare software to filter out the objects.you can use export/import wizard to copy the table dataRegards,Ahmad Osama |
|
|
|
Andre412
Starting Member
11 Posts |
Posted - 2009-05-05 : 11:08:42
|
| Or you can script out the objects in the dev system that do not exist in the livebackup the live to a .bak filerestore the backup to the dev, replaceing the existing devrun the aforementioned scripts to bring back your unique objects into devthats what i would do. It would be faster and easier |
|
|
|
|
|
|
TABLE EXPORT WITH DATA