transfer tables with constraints and associative procedures from one database to another

Question

0.00/5 (No votes)

See more:

hi,

In my organisation every application has its own database.so 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.

thanks.

Posted 8-Jul-13 3:04am

ruby kaur

Add a Solution

Comments

_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

Add a Solution

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

Adarsh chauhan · Accepted Answer · 2013-07-08T19:31:00

Hi,

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

http://blog.sqlauthority.com/2011/05/07/sql-server-2008-2008-r2-create-script-to-copy-database-schema-and-all-the-objects-data-schema-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/[^]

transfer tables with constraints and associative procedures from one database to another

1 solution

Solution 1

Add your solution here

Preview 0

transfer tables with constraints and associative procedures from one database to another

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us