how to import and export database in sql Server 2019



how to import and export database in sql Server 2019

how to import and export database in sql Server 2019

How to import & export Sql database file from
Sql database software

Open Sql Software Studio

Connect server

Now you see somes folders

click on Database folder

select Database file for exporting

right click and select Export Data-tier

Application

Now click next

Save file

name same as database name

click next

data exporting…….

Exporting done

Now how we can import database file
again into software

right click on Database folder

select Import Data-tier Application

click next

broswer file

change your databasename if you
want
i have already this name database
so i change this name

Now data importing ………

Congrats

Subscribe our channel
for more videos

Thanks

how to import and export database in sql Server 2019,
How to Connect to SQL Server after Installation,
how to use sql server,
import & export,
how to import database in sql Server 2019,
how to export database in sql Server 2019,
how to import Data-tier application file to sql serve,
how to export Data-tier application file to sql serve,
Data-tier application ,
microsoft sql server management studio,

download link : https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

Sql server download : https://www.microsoft.com/en-us/sql-server/sql-server-downloads

Comments are closed.