Skip to Content.
Sympa Menu

freetds - Re: [freetds] datacopy syntax

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] datacopy syntax
  • Date: Fri, 19 Aug 2011 20:01:23 -0400

On Wed, 17 Aug 2011 09:26:50 +0200
Frediano Ziglio <freddy77 AT gmail.com> wrote:

> > The current parameters are:
> >
> >        [-S server/username/password/database/table_or_view]
> >        [-D server/username/password/database/table]
> >
> > You see the problem immediately: how to omit the username &
> > password?
> >
>
> Use strsep instead of strtok and pass empty strings like
>
> -S my_server///my_db/my_table

Yes, that would work. But if datacopy honored $DSQUERY and the default
dbname was OK, the syntax would be

////my_table

which is just plain ridiculous, don't you agree? Besides, nowhere else
do we use slashes that way.

> > I propose to change the syntax to emulate a URL:
> >
> >        -S [username[:passwd]@][dbname.][schema.]tablename
>
> why not using another parameter like --source to avoid clash?

(BTW, the above syntax left out the servername by mistake.)

Simpler code. Simpler documentation. Better usability.

--jkl




Archive powered by MHonArc 2.6.24.

Top of Page