The best way to do this is through the ARS:
1. Create a new instance of ARS connected to the New (MS/SQL) DB. Feel free
to use a newer version of ARS.
2. Get a FREE copy of rrrChive from rrr.se.
3. Use rrrChive to copy ('Sync') all forms from the old server to the new.
4. Done!
You can speed up the process by running rrrChive in multiple CMD windows;
use a separate .cfg file for each thread. Be sure the 'target' ARServer has
enough 'fast servers' available.
If you're moving a lot of data, install rrrChive on the 'source' server;
reading ('list servers') runs faster than writing.
I've let rrrChive run overnight and never had a problem (except when the
source was taken down for backups).
HTH,
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Kelly Gatewood
Sent: Monday, November 29, 2010 5:15 PM
To: arslist@ARSLIST.ORG
Subject: Database Migration Question
--_000_C09D1A97D9D49841B2F6A7D6CBA3234458C0482D99EXVMBX0181exc_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Dear Listers,
I was wondering if anyone has successfully converted a BMC Remedy Oracle DB=
to a SQL DB?
I have a customer wishing to switch platforms without doing a traditional m=
igration.
Thanks
Kelly Gatewood
____________________________________________________________________________
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11
www.wwrug.com ARSList: "Where the Answers Are"
--_000_C09D1A97D9D49841B2F6A7D6CBA3234458C0482D99EXVMBX0181exc_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
**
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml"; xmlns=3D"http:=
//www.w3.org/TR/REC-html40"><head><meta http-equiv=3DContent-Type content=
=3D"text/html; charset=3Dus-ascii"><meta name=3DGenerator content=3D"Micros=
oft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]--></head><body lang=3DEN-US link=3Dblue vli=
nk=3Dpurple><div class=3DWordSection1><p class=3DMsoNormal>Dear Listers,<o:=
p></o:p></p><p class=3DMsoNormal><o:p> </o:p></p><p
p>class=3DMsoNormal>=
I was wondering if anyone has successfully converted a BMC Remedy Oracle DB=
to a SQL DB?<o:p></o:p></p><p class=3DMsoNormal><o:p> </o:p></p><p cl=
ass=3DMsoNormal>I have a customer wishing to switch platforms without doing=
a traditional migration.<o:p></o:p></p><p class=3DMsoNormal><o:p> </o=
:p></p><p class=3DMsoNormal>Thanks<o:p></o:p></p><p class=3DMsoNormal><o:p>=
</o:p></p><p class=3DMsoNormal><b>Kelly Gatewood<o:p></o:p></b></p></=
div></body></html>=
_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
--_000_C09D1A97D9D49841B2F6A7D6CBA3234458C0482D99EXVMBX0181exc_--
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
