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 |
|
silas2
Yak Posting Veteran
65 Posts |
 Posted - 2007-03-22 : 15:49:28
|
| I'm using an ISP with SQL Server, the Database Publishing Wizard worked great to create a text.sql file which recreated the exact replica of the local db on the ISP's SQL Server. But, is there a code library for this somewhere so I can run this automatically on the the server and post the text.sql file off as a local backup? |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-03-22 : 16:00:42
|
| Why not just use the regular SQL Server backup?CODO ERGO SUM |
 |
|
|
silas2
Yak Posting Veteran
65 Posts |
Posted - 2007-03-22 : 19:21:59
|
| Because the users want to see a plain text dump of their data - it's taken me an age to wean them off Excel and the boss doesn't trust data stored off-site in this new-fangled relational format.I suppose I could just write a routine "select all from all non-system tables" and parse the records into a csv or a load of insert statements - I'm just getting coding fatigue, I wondered if there was a boiler plate version. |
|
|
|
|
|
|
ISP - create text dump