Microsoft SQL Server

RT Users
1

I have RT up and running on a Fedora Linux box running mySQL. My company has
several production SQL servers that are backed up, raided, etc running
Microsoft SQL Server.

Is it possible to move the DB from my Linux box to SQL Server? From my
company’s perspective, there are lots of advantages to doing this.

I am not concerned with moving Data over to the new box (we are just
starting to use it) but does anyone have a script to create the appropriate
tables and permissions? We are also using RTFM.

I assume that it is just a matter of editing the config file to point to the
new database location.

Any help would be great!

Thanks
Brett

2

I have RT up and running on a Fedora Linux box running mySQL. My company has
several production SQL servers that are backed up, raided, etc running
Microsoft SQL Server.

Is it possible to move the DB from my Linux box to SQL Server? From my
company’s perspective, there are lots of advantages to doing this.

I am not concerned with moving Data over to the new box (we are just
starting to use it) but does anyone have a script to create the appropriate
tables and permissions? We are also using RTFM.

I assume that it is just a matter of editing the config file to point to the
new database location.

Any help would be great!

A quick look at RT (rt-3.2.1) tells me that RT does not support
Microshit SQL servers.

This was gleaned from the ./configure options for rt-3.2.1 :

–with-db-type=TYPE sort of database RT will use (default: mysql)
(mysql, Pg, Oracle, Informix and SQLite are valid)

Which one of those is SQL server?

    cheers
   - wash

Odhiambo Washington . WANANCHI ONLINE LTD (Nairobi, KE) |
. 1ere Etage, Loita Hse, Loita St., |
GSM: (+254) 722 743 223 . # 10286, 00100 NAIROBI |
GSM: (+254) 733 744 121 . (+254) 020 313 985 - 9 |
“Oh My God! They killed init! You Bastards!”
–from a /. post

3

Brett Barnhart wrote:

I have RT up and running on a Fedora Linux box running mySQL.
My company has several production SQL servers that are backed
up, raided, etc running Microsoft SQL Server.

Is it possible to move the DB from my Linux box to SQL Server?
From my company’s perspective, there are lots of advantages to
doing this.

I am not concerned with moving Data over to the new box (we are
just starting to use it) but does anyone have a script to create
the appropriate tables and permissions? We are also using RTFM.

I assume that it is just a matter of editing the config file to
point to the new database location.

You know what they say about assumptions…

RT to my knowledge does not yet run on MS SQL Server. There’s a different
variant of SQL for each database vendor. The schema definition, sql querying
syntax, and optimizations of indexes, constraints, etc. will be different
for mysql, postgresql, oracle, etc.

That said, the design of RT makes the support of other database backends
possible. But it will still be a lot of work. -Unless someone is sitting on
the code for the MS SQL support…

I’m a lurker on the RT lists. The initial need which led me to investigate
RT went away. But I’m still lurking, hoping to find the time and an excuse
to bring up a production implementation of RT for some purpose or another.
If/when I find the excuse, I’ll be in the same camp as you.

So please, keep me updated on your progress. And if you get stuck or need a
second opinion, drop me a note.

If you haven’t already, you’ll probably want to check out www.freetds.org.
FreeTDS is a project which implements the tabular datastream protocol which
you can use on UNIXes with Perl and DBD::ODBC or DBD::Sybase to communicate
with Sybase and MS SQL database servers.

Garrett

Garrett Goebel
IS Development Specialist

ScriptPro Direct: 913.403.5261
5828 Reeds Road Main: 913.384.1008
Mission, KS 66202 Fax: 913.384.2180
www.scriptpro.com garrett at scriptpro dot com