<div>
I don't think there's any way to pick and choose what it'll restore. &nbsp;When you restore the file (let's say it's called MIRCCISDATA), change the name by modifying the name in the To database field. &nbsp;Then, copy the views and procedures from the new version to the old version (I've only got Express to practice on right now so I have to copy the script from the view to the new view in the other dB, but I think there's a way to copy the views and procedures in full-blown SQL--right-click the view and check it out).
</div>


I don't think there's any way to pick and choose what it'll restore.  When you restore the file (let's say it's called MIRCCISDATA), change the name by modifying the name in the To database field.  Then, copy the views and procedures from the new version to the old version (I've only got Express to practice on right now so I have to copy the script from the view to the new view in the other dB, but I think there's a way to copy the views and procedures in full-blown SQL--right-click the view and check it out).

<div>
Hi,<br />
You can modify the model database to make it(via scripts ) as your template, then every new database u create will be like your template.
</div>


Hi,
You can modify the model database to make it(via scripts ) as your template, then every new database u create will be like your template.

<div>
<div class="content wysiwyg-content">
I'm just wondering is it possible to restore old database with new &quot;version&quot; of same database? I just want new fields, views and procedures from new version to old version and same time keeping data in old version.<br />
<br />
Help needed, thanks!
</div>
</div>


I'm just wondering is it possible to restore old database with new "version" of same database? I just want new fields, views and procedures from new version to old version and same time keeping data in old version.

Help needed, thanks!

How to Restore MS SQL database without data

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.