Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mridang_agarwal
Starting Member
22 Posts |
 Posted - 2007-03-02 : 04:56:36
|
| Hey Guys,I do alot of development on my personal machine and have quite few databases in SQL Server. My PC is very prone to crashing :-p so Im writing a custom batch script to backup up all my data. How can I backup my SQL Server databses into a text file. I dont want to use the BAK file. In MYSQL this is a relatively simple process where i just have to use the mysqldump utility which scripts 'all' my databases (structure and data). Can I do the same thing in SQL Server? Please tell me a way. Its going to save me a lot of trouble.Thanks in advance guys. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-03-02 : 05:16:36
|
| this creates insert scripts for your data.but you'll have to write code for your databaseshttp://vyaskn.tripod.com/code.htm#insertsCausing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
mridang_agarwal
Starting Member
22 Posts |
Posted - 2007-03-02 : 06:05:05
|
| Isn't there any kind of tool or something. How would this help? I need to backup the structure too and all into a single text file. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-03-02 : 06:26:52
|
| search on google. i don't know of such a tool. but it probably exists.there is no such tool that comes with sql serverCausing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-03-02 : 06:33:08
|
| Sometimes ago Peter posted a link about an SQL tool which he found on Microsoft site.Just can't find it.....!!!Oh, yes..here it is:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73608&SearchTerms=script,data[/url]Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-03-02 : 08:21:10
|
| There is no good reason for you to not use BACKUP.Just use the tool provided.CODO ERGO SUM |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
|
|
|
|
|
dumping all databses