Re: FreeBCP to SQL Azure complains table is missing?
phineas vang <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Hi, I have to convert a sql 2005 database to sql 2000 to run a perl script with the win 32: :odbc connection. This is a repetitive process. I do not know anything about perl coding. Is Free TDS the correct tool for me to be able to run my perl scrip from sql 2005 rather than having to convert it sql 2000? Thanks in advance! > From: [email protected] > Date: Wed, 21 Nov 2012 10:05:23 -0500 > To: [email protected] > Subject: Re: [freetds] FreeBCP to SQL Azure complains table is missing? > > > Awesome! When will the build system update these files and to which version numbers? > ftp://ftp.astron.com/pub/freetds/ > > - Ken > > On Nov 21, 2012, at 9:37 AM, Frediano Ziglio <[email protected]> wrote: > > > See change > > > > http://gitorious.org/freetds/freetds/commit/4a21ded022405693607e71938d0c6173816f5ff9/diffs/c34afafd2fec4cbba9b245e4f13a5471c6fb8041 > > > > (add support for -D in freebcp) > > > > Frediano > > > > 2012/11/21 Ken Collins <[email protected]>: > >> > >> I have not hit that need yet, but being able to use everything from tsql to freebcp with Azure would be cool. > >> > >> - Ken > >> > >> On Nov 20, 2012, at 11:03 PM, "James K. Lowden" <[email protected]> wrote: > >> > >>> On Tue, 20 Nov 2012 21:04:39 -0600 > >>> Cade Roux <[email protected]> wrote: > >>> > >>>> I expect that workaround will not work because USE isn't supported - > >>>> you do in fact have to connect directly to the database, because of > >>>> the nature of the SQL Azure architecture. > >>> > >>> Yes, you're right. I forgot about that. > >>> > >>> About a year ago we added the DBSETLDBNAME macro as a way to set the > >>> dbname in the db-lib LOGINREC. That sets the dbname in the login > >>> packet, obviating the need for "USE dbname". freebcp could be modified > >>> to support that feature with a -D option. > >>> > >>> --jkl > >>> _______________________________________________ > >>> FreeTDS mailing list > >>> [email protected] > >>> http://lists.ibiblio.org/mailman/listinfo/freetds > >> > >> _______________________________________________ > >> FreeTDS mailing list > >> [email protected] > >> http://lists.ibiblio.org/mailman/listinfo/freetds > > _______________________________________________ > > FreeTDS mailing list > > [email protected] > > http://lists.ibiblio.org/mailman/listinfo/freetds > > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds