sql server backup (1 Viewer)

Isaac

Lifelong Learner
Local time
Today, 05:03
Joined
Mar 14, 2017
Messages
8,738
What is the proper term for one of those sql server backups where what you end up with is a text file containing the full ddl / t-sql that would be required to 1) re-create the tables using ddl, and 2) insert all of the values using t-sql? like full, differential, file, etc
 

theDBguy

I’m here to help
Staff member
Local time
Today, 05:03
Joined
Oct 29, 2018
Messages
21,358
Hi. Not sure if this is what you meant but try searching for: "Script Database As"

Hope it helps...
 

Isaac

Lifelong Learner
Local time
Today, 05:03
Joined
Mar 14, 2017
Messages
8,738
Yes! that works, after a bit more reading I can just say I have a script generating from someone scripting database objects with data, thank you dbGuy :)
 

theDBguy

I’m here to help
Staff member
Local time
Today, 05:03
Joined
Oct 29, 2018
Messages
21,358
Yes! that works, after a bit more reading I can just say I have a script generating from someone scripting database objects with data, thank you dbGuy :)
Hi. Glad to hear you got it sorted out. Cheers!
 

Users who are viewing this thread

Top Bottom