In this
article, we will learn the ReportServer in the SQL
Server.
1.First
of all, Open the Microsoft SQL Server Management Studio.
2.Connect
to the SQL Server instance which the database you want to script belongs to.
3.In the
Object Explorer window, drill to the database you want to script objects as well
as table data.
4.Right
click on the ReportServer which you want to script all ReportServer
objects.
5.On the
context menu, select Tasks and then choose Generate Scripts...
menu item. We are now starting a new tool SQL Server script database wizard.
Image
1.
6.Follow
the steps in the wizard to script the database objects.
Image
2.
7.The
script wizard dialog box is started and Select Database step is
displayed.The database on which we right clicked is selected by default in this
step, you can alternately switch to a different database by selecting the
database name in the list.I would like to script the reportServer database on my
named instance ReportServer, Hence the database name ReportServer.
Click Next button to move to the next step.
Image
3.
8. The
next screen of the Script Wizard is Choose Script Options screen.This
screen is the place where you can configure the features of your database
scripts.You can identify data scripting, trigger scripting, script for defaults,
collation, permissions, statistics, extended properties, as well as create and
drop objects, etc.
Image
4.
9. All of
the options are Boolean values and you can change to True or False depending on
your choice. I am changing the Script Data option to
True in the screen.
Image
5.
10. After
you have identified the scripting properties of your database script, next
screen is identifying the object types you want to create scripts.
Image
6.
11.
Following
screen in the sql script wizard is the Choose the database roles
screen. Click the Select All button for enabling scripting for all database
tables.
12. Following screen in the sql script wizard is the Choose the
Schemas screen. Click the Select All button for enabling scripting for all
database tables.
13.Next screen is choosing from the list of all stored procedures in the
related sql database. Check option Select All for scripting for all stored
procedures.
14. Following screen in the sql script wizard is the Choose Tables
screen. Click the Select All button for enabling scripting for all database
tables.
15. Following screen in the sql script wizard is the Choose User screen.
Click the Select All button for enabling scripting for all database tables.
16. Following screen in the sql script wizard is the Choose Views screen.
Click the Select All button for enabling scripting for all database tables.
17. After
selecting all the SQL Server 2008 database objects that you want to create
scripts for, it is time to define the output properties of the scripting wizard.
We can script to a file, create a single script file or seperate scripting
files per object in the database.
Image
7.
18.
Before we can finish sql database script configuration and start scripting all
objects in the sql database is the Script Wizard Summary screen.
Image
8.
19.Last
screen, Generate Script Process
Image
9.
20. We
can enable scripting wizard to script to the clipboard or script into a new
Query Window.
Image
10.
I hope
this article will help you.