how to import and export database in sql Server 2019

preview_player
Показать описание
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,

Рекомендации по теме
Комментарии
Автор

So simple, so quick. Thanks for the video!

carolinavval
Автор

Thank you for posting this video, I was able to accomplish my task using your instructions.

xrdang
Автор

For some reason the job fails if you have a sequence container when you try to run it on SQL Server Agent. Maybe someone can explain?

puki
Автор

how can I import into the existing database on another SQL Instance ?? When I tried its gave an error

AAli
Автор

for some how its showing me Operation failed error message

edemdaglo
Автор

How to export Only Schema and export it as .SQL format ?

tech_with_manindra
Автор

plz add Backup file in your YT video. it is importing and exporting of backup files.

m
Автор

how can I import a database of .db extension(sqlite3) to SSMS?

shivamburnwal
Автор

Any option to only extract a specific table from database

sobhithapachipulusu
Автор

sorry sir. this is not my database code, this is some keyboard slam. I am not sending this to my teacher. you didn't help me

JanKowalski-wejp