[TriLUG] transferring database contents

[Tim Jowers]

Brian,

You might know this but the formula is.

1. download JAva database driver for your RDBMS (jdbc driver. type 4 is
best)
2. tell squirrel where to find it (drivers)
3. enter your database connection string. SQuirreL has some examples or
search the web. colons and slashes separate the important stuff (machine/ip,
port, db, username, password). Varies by db vendor.
4. Add the alias to your database.

Let us know how this goes. I keep meaning to play with DBCopy but haven't.

Thanks!
TimJowers


On Sun, Jun 20, 2010 at 3:20 PM, Brian McCullough <bdmc at bdmcc-us.com> wrote:

> On Sun, Jun 20, 2010 at 09:09:13AM -0400, Robert Dale wrote:
> > Take a look at SQuirrel SQL. You could also use DBCopy (within
> > squirrel) to copy straight to postgresql.
>
> Thank you very much, Robert.  That looks like exactly what I needed.  Now I
> just have to figure out how to connect it to the SQL Server Express instance
> on the same machine.
>
>
> Brian
>
> --
> This message was sent to: timjowers <timjowers at gmail.com>
> To unsubscribe, send a blank message to trilug-leave at trilug.org from that
> address.
> TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug
> Unsubscribe or edit options on the web  :
> http://www.trilug.org/mailman/options/trilug/timjowers%40gmail.com
> TriLUG FAQ          :
> http://www.trilug.org/wiki/Frequently_Asked_Questions
>