[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sonar-dev
Subject:    Re: [sonar-dev] Re: Migrating sonar database from SQL server to mySQL
From:       Freddy Mallet <freddy.mallet () gmail ! com>
Date:       2013-05-20 13:17:52
Message-ID: CAPyGxijPjKhpGWksaEPGR15Nnsde_Ez9M87q__XChmbzbKYqDg () mail ! gmail ! com
[Download RAW message or body]

Hi Radhika,

As the number of pitfalls in this migration process is really important, we
highly advice to not do it. If you don't use yet the "review" concept,
might be a better solution to start from scratch and to reimport the
history on your projects with help of the sonar.projectDate property.

Kind regards

-----
twitter.com/FreddyMallet
Sonar for Continuous Inspection


On Wed, May 15, 2013 at 4:45 PM, Radhika Kilaru <rkilaru1912@gmail.com>wrote:

> Sorry, Tables in both servers are same. Shall I use any migration tool to
> migrate? or else any other process to do this?
>
>
> On Wed, May 15, 2013 at 8:14 PM, Radhika Kilaru <rkilaru1912@gmail.com>wrote:
>
>> Hi All,
>>
>> Currently we are using SQL Server 2010 as backend to capture sonar(3.14)
>> results. Since it needs license, we thought os migrating it to
>> mySQL(5.5.30). I am able to change the configurations and sonar tables are
>> created successfully in mySQL. Now my question is how can I migrate SQL
>> server data to mySQL? I observered that the list of tables available in
>> both servers are different. Can anyone have any idea?
>>
>> Regards,
>> Radhika
>>
>
>

[Attachment #3 (text/html)]

<div dir="ltr">Hi <span class="" style>Radhika</span>,<div><br></div><div style>As \
the number of pitfalls in this migration process is really important, we highly \
advice to not do it. If you don&#39;t use yet the &quot;review&quot; concept, might \
be a better solution to start from scratch and to <span class="" \
style>reimport</span> the history on your projects with help of the sonar.<span \
class="" style>projectDate</span> property.  </div> <div style><br></div><div \
style>Kind regards</div></div><div class="gmail_extra"><br \
clear="all"><div><div><span \
style="font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">-----</span></div><div>
 <a href="https://twitter.com/FreddyMallet" \
style="font-family:arial,sans-serif;background-color:rgb(255,255,255)" \
target="_blank">twitter.com/FreddyMallet</a></div><div><span \
style="background-color:rgb(255,255,255)">Sonar for Continuous \
Inspection</span></div> </div>
<br><br><div class="gmail_quote">On Wed, May 15, 2013 at 4:45 PM, Radhika Kilaru \
<span dir="ltr">&lt;<a href="mailto:rkilaru1912@gmail.com" \
target="_blank">rkilaru1912@gmail.com</a>&gt;</span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"> Sorry, Tables in both servers are same. Shall I use any \
migration tool to migrate? or else any other process to do this?<div \
class="HOEnZb"><div class="h5"><div><br></div><div><br><div class="gmail_quote">On \
Wed, May 15, 2013 at 8:14 PM, Radhika Kilaru <span dir="ltr">&lt;<a \
href="mailto:rkilaru1912@gmail.com" \
target="_blank">rkilaru1912@gmail.com</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">Hi All,<div><br></div><div>Currently we are using SQL Server \
2010 as backend to capture sonar(3.14) results. Since it needs license, we thought os \
migrating it to mySQL(5.5.30). I am able to change the configurations and sonar \
tables are created successfully in mySQL. Now my question is how can I migrate SQL \
server data to mySQL? I observered that the list of tables available in both servers \
are different. Can anyone have any idea?</div>


<div><br></div><div>Regards,<br>Radhika</div>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div>



[prev in list] [next in list] [prev in thread] [next in thread]