[CLUE-Tech] OT: SQL Server dump-to-text

[David Willson]

How bout this for an idea?
Set up your mySQL server as an ODBC datasource on your Windows box, then
use DTS to export directly to it?  That should do it in one shot.

On Fri, 2001-12-28 at 11:46, Dave Anselmi wrote:
> David Willson wrote:
> 
> > Chris and Dave were right.  There is no option to script the data along with
> > the DDL.
> >
> 
> I didn't really say that, since I thought that part of the problem wasn't an
> issue.  Back to the books on-line:
> 
> <quote>
> DTS can also copy schema and data between relational databases. ...Using the DTS
> object transfer capability, you can also copy indexes, stored procedures,
> referential integrity constraints, and other database objects between computers
> running Microsoft® SQL Server™ version 7.0.
> </quote>
> 
> DTS is data transformation services.  There may be other ways to do this, too -
> no idea what the best solution is.  Further down, there's this list of data
> sources that DTS can import, export, and transform between:
> 
> <quote>
> ASCII fixed-field length text files
> ODBC data sources
> SQL Server databases
> Microsoft Excel spreadsheets
> Microsoft Access databases
> Microsoft FoxPro® databases
> dBase or Paradox databases
> User-specified OLE DB data sources
> </quote>
> 
> So I think that one way or another, what you're trying to do is possible.  I
> sympathize completely that figuring out how MS intends things to be done is not
> always an easy task.  I assume they have classes or books or consultants who
> know, but I don't know the magic to help you find out yourself.
> 
> In this case though, the books on-line is more useful than I expected (well, I
> haven't used them to actually *do* anything, so they may just add to your
> irritation).  What I have is 12MB, most all in one file, and I'd be happy to
> share.  It comes on the SQL Server install media, so you can find it that way,
> too.
> 
> Dave
> 
> 
> _______________________________________________
> CLUE-Tech mailing list
> CLUE-Tech at clue.denver.co.us
> http://clue.denver.co.us/mailman/listinfo/clue-tech