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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-21 : 10:29:21
|
| Francis writes "I was just wondering, I need to export 900+ tables in three different SQL 7.0 databses to text files. I know that I can do them one at a time through DTS, but is there a simpler and faster way to transport all tables one time?" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-08-21 : 12:06:35
|
| Create a script using bcpsomething likeselect 'bcp mydb.dbo.' + name + ' out ' + name + '.txt -S<servername> -Usa -Ppwd'from sysobjects where type = 'U'Can also put these commands into a temp table and run them using xp_cmdshell or into a file and use osql.I prefer to just copy the output.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Exporting All database tables at once