<div>
It looks great!!.....I'll have a look at it, and I'll inform you of the results......<br />

</div>


It looks great!!.....I'll have a look at it, and I'll inform you of the results......


<div>
The tool is fine......thanks for the link!!<br />

</div>


The tool is fine......thanks for the link!!


<div>
You bet--they do have some very nice products!
</div>


You bet--they do have some very nice products!

<div>
<div class="content wysiwyg-content">
Hey experts,<br />
<br />
I have on MS SQL Server one base DB, and 5 additional DBs which are similar to the first, but they have no data (or at least they have different data from each others and from the base DB). The base DB is the one that is used for testing the software on it, when something appears wrong in the meta-data of this base DB it is being corrected on it (like a field in a table which turns out that it should accept a NULL value or have a default value); this change in the meta-data of the base DB means that I have to do the same change in the 5 other DBs. Is there any way that could allow me to copy the new state of the base DB's meta-data onto the other 5 DBs (using some Stored Procedure or something similar), so I don't have to keep on repeating the changes that I do everytime, 5 times??<br />

</div>
</div>


Hey experts,

I have on MS SQL Server one base DB, and 5 additional DBs which are similar to the first, but they have no data (or at least they have different data from each others and from the base DB). The base DB is the one that is used for testing the software on it, when something appears wrong in the meta-data of this base DB it is being corrected on it (like a field in a table which turns out that it should accept a NULL value or have a default value); this change in the meta-data of the base DB means that I have to do the same change in the 5 other DBs. Is there any way that could allow me to copy the new state of the base DB's meta-data onto the other 5 DBs (using some Stored Procedure or something similar), so I don't have to keep on repeating the changes that I do everytime, 5 times??


Meta-Data Copying in MS SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.