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

[Chris K. Chew]

I'll tell ya, I have had nothing but headaches over a client's sql server in
the past few weeks.  It is like the initial design session went something
like this:

Designer 1:  "What is essential to a stable, fast SQL-based data server?"
Designer 2:  "Who cares?  How can we use buzz-words like xml, replication
and clustering?"
Designer 1:  "Oh yeah, I see your point.  I was out of line, sorry."

Anyways, please let me know if anyone finds an easy way of transferring data
and structure from ms sql server to mysql.

Thanks for the help!

Chris

-----Original Message-----
From: clue-tech-admin at clue.denver.co.us
[mailto:clue-tech-admin at clue.denver.co.us]On Behalf Of David Willson
Sent: Thursday, December 27, 2001 3:50 PM
To: clue-tech at clue.denver.co.us
Subject: RE: [CLUE-Tech] OT: SQL Server dump-to-text


Chris and Dave were right.  There is no option to script the data along
with the DDL.

On Tue, 2001-12-25 at 10:12, David Willson wrote:
> I think there's an option to script the data, too.  I'll check tomorrow at
> work.
>
> -----Original Message-----
> From: clue-tech-admin at clue.denver.co.us
> [mailto:clue-tech-admin at clue.denver.co.us]On Behalf Of Dave Anselmi
> Sent: Sunday, 23 December, 2001 11:53
> To: clue-tech at clue.denver.co.us
> Subject: Re: [CLUE-Tech] OT: SQL Server dump-to-text
>
>
> "Chris K. Chew" wrote:
>
> > Well yes, and no.
> >
> > To clarify, I found that SQL Server is able to dump the database to a
> > records-only sql text file.  The file will contain no information about
> the
> > table structures, however.  I was hoping that ms would remain faithful
to
> > the SQL standard and give me a genuine sql dump of the database
including
> > CREATE TABLE statements.  I searched both the Internet and every related
> > book in the local computer bookstore, but couldn't find anything telling
> me
> > that it can do it, much less how to do it.  I like to know how, if it is
> > indeed possible.
>
> Look in the SQL Server books on-line, in the howto section (enterprise
> manager,
> and databases):
>
> <quote>
> To generate a script
>
> Expand a server group; then expand a server.
> Expand Databases, right-click the database to script, point to All Tasks,
> and
> then click Generate SQL Scripts....
> On the General tab, select the database objects to script. By default, all
> objects in the database are scripted.
> On the Formatting tab, select from the script formatting options:
> </quote>
>
> And so on...
>
> Seems that this is just what you are looking for.  Of course the script
may
> be
> transact-sql and may require massaging to work with another db.  And you
> already
> know how to dump the data itself.
>
> Dave
>
>
> _______________________________________________
> CLUE-Tech mailing list
> CLUE-Tech at clue.denver.co.us
> http://clue.denver.co.us/mailman/listinfo/clue-tech
>
> _______________________________________________
> CLUE-Tech mailing list
> CLUE-Tech at clue.denver.co.us
> http://clue.denver.co.us/mailman/listinfo/clue-tech


_______________________________________________
CLUE-Tech mailing list
CLUE-Tech at clue.denver.co.us
http://clue.denver.co.us/mailman/listinfo/clue-tech