a) Open SSMS (SQL server management studio)
b) Select server type in the following
Database engineàTo connect and work with normal database.
Integration service à To and work with normal database.
Analysis service àTo connect and work with analysis service database.
Reporting servicesà To connect and work reporting services databases.
SQL server compact EditionàTo connect and work with mobile applications.
c) Server name –> Either IP Address (or) actual server name.
d) Select authentication –>
i) Window authentication –> Consider window credentials to logon
ii) SQL server Authentication –> Server database credentials. Note: Select the option: ii)for the real time work process.
e) Click connect…. Next…
Creating databases –> Right click on database
New database window
Database Name: DMNEW
–> Click ok
Creating tables –> DBNe3wq –> Tables –> Right click–> Select ‘new tables’
Column Name Data Type
PARTY ID Int
PARTY NAME VARCHAR (50)
–> Next save the table with a specified Name i.e, PARTY
–> Click OK.
FREE Demo Class From Industry Experts - Enroll Now.!!SSIS training
Adding data to the tables of the database
–> Right click on TABLE –> Select the option “edit top 200 rows”. PARTY ID PARTY NAME
Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.