<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2657.73">
<TITLE>RE: [rt-users] Microsoft SQL Server</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Brett Barnhart wrote:</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> I have RT up and running on a Fedora Linux box running mySQL.</FONT>
<BR><FONT SIZE=2>> My company has several production SQL servers that are backed</FONT>
<BR><FONT SIZE=2>> up, raided, etc running Microsoft SQL Server.</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> Is it possible to move the DB from my Linux box to SQL Server?</FONT>
<BR><FONT SIZE=2>> From my company's perspective, there are lots of advantages to</FONT>
<BR><FONT SIZE=2>> doing this.</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> I am not concerned with moving Data over to the new box (we are</FONT>
<BR><FONT SIZE=2>> just starting to use it) but does anyone have a script to create</FONT>
<BR><FONT SIZE=2>> the appropriate tables and permissions? We are also using RTFM.</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> I assume that it is just a matter of editing the config file to</FONT>
<BR><FONT SIZE=2>> point to the new database location.</FONT>
</P>
<P><FONT SIZE=2>You know what they say about assumptions...</FONT>
</P>
<P><FONT SIZE=2>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.</FONT></P>
<P><FONT SIZE=2>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...</FONT></P>
<P><FONT SIZE=2>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.</FONT></P>
<P><FONT SIZE=2>So please, keep me updated on your progress. And if you get stuck or need a second opinion, drop me a note.</FONT>
</P>
<P><FONT SIZE=2>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.</FONT></P>
<P><FONT SIZE=2>Garrett</FONT>
</P>
<P><FONT SIZE=2>--</FONT>
<BR><FONT SIZE=2>Garrett Goebel</FONT>
<BR><FONT SIZE=2>IS Development Specialist</FONT>
</P>
<P><FONT SIZE=2>ScriptPro Direct: 913.403.5261</FONT>
<BR><FONT SIZE=2>5828 Reeds Road Main: 913.384.1008</FONT>
<BR><FONT SIZE=2>Mission, KS 66202 Fax: 913.384.2180</FONT>
<BR><FONT SIZE=2>www.scriptpro.com garrett at scriptpro dot com</FONT>
</P>
</BODY>
</HTML>