Click here to Skip to main content
15,746,107 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:

In my organisation every application has its own there is replication of master data in every database.
now i have to make centralized Master database from several other databases.
i have to transfer all the master tables with constraints and their associated stored procedures,function ,views form other databases to this centralized database.
how can i this implement so that most current and all dependent object are come under one roof successfully.please guide me.
we are using sql server 2008 R2.

_Asif_ 8-Jul-13 9:07am    
Why dont you use SQL Server replication for this purpose?
ruby kaur 9-Jul-13 1:43am    
i think replication is not useful in my case.because my task is to make centralized database for all the master tables. right now every application is using its own set of master tables which is causing data redundancy now i have to shift all master tables in centralized database and application specific and transnational tables in applications own database.

1 solution


you can generated script for that in sql server 2008 r2..

1) just Right click on your database.
2)go to task
3) select "Generate Scripts"
4) follow the steps as per instructions given on the screen.
and there you go..

for details go through the below link..[^]
Share this answer
ruby kaur 9-Jul-13 1:47am    
thankyou this will work for me.
Adarsh chauhan 9-Jul-13 1:50am    
you are most welcome.. :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900