Subject: Re: Database dump
From: "Michael B" <[email-masked]>
To: "Yelitza Parra" <[email-masked]>, "Justin Fata" <[email-masked]>
Cc: "CakeDC Development Team" <[email-masked]>, "Destavioun Carr" <[email-masked]>, "Jeremy Leonard" <[email-masked]>
Date: Tue, 22 May 2018 11:35:14 -0400

I think 10:00 CST  (11:00 EST) would be ok. 
Thank you,
Michael Bishop
Labor Law Poster Service
877-321-4144 x355

From: Yelitza Parra 
Sent: Tuesday, May 22, 2018 9:58 AM
To: Justin Fata 
Cc: CakeDC Development Team ; Destavioun Carr ; Jeremy Leonard ; Michael B 
Subject: Re: Database dump

yes thursday is okay. is 10 or 11 am CST okay for you guys? or 1pm? 

On Fri, May 18, 2018 at 8:01 PM, Justin Fata <[email-masked]> wrote:

  Can we do Thursday? I want to make sure Jeremy can be on the call. 

  On Fri, May 18, 2018 at 5:23 PM Yelitza Parra <[email-masked]> wrote:

    As I understand you would like to have several companies in the same database/system and each company could have its own products, users, payments, etc. It would be good to have a call next week to understand the big picture and make sure we both are on the same page.  

    I just created a user for Jeremy, he should have received an email with redmine details. This is the ticket about the database migration  https://redmine.cakedc.com/issues/23163.

    I will be off on Monday, I am available Tuesday for the meeting, let me know what time works for you all. 

    Thank you, 

    On Fri, May 18, 2018 at 1:08 PM, Justin Fata <[email-masked]> wrote:

      Hi Yelitza and Cake Team, 

      There are a few things that I wanted to mention as you guys move forward with the database migration; I want to make sure that the corporate records and labor law site are set up on the same system and we have the capability to add new companies and products in the future. Right now the database is only set up for one company and we have 2 completely separate databases for our Corporate and Labor Law product. Jeremy informed me that this is going to need to be done in the initial database setup so I wanted to communicate to you this is how we want it done.

      Jeremy knows the most about how the database is setup and can answer questions about the database better than anyone. Please feel free to reach out to him if you have any questions. Also, could you please send him a link to login to the ticketing system?

      Thanks,

      Justin

      On Thu, May 17, 2018 at 5:24 PM, Yelitza Parra <[email-masked]> wrote:

        Sure, we will start on this right now.  

        Thank you,  

        On Thu, May 17, 2018 at 2:48 PM, Justin Fata <[email-masked]> wrote:

          Hi Yelitza, 

          The estimate is fine, we approve. I am also adding Jeremy to this email. I would like to keep him on the email threads moving forward.

          Best,

          Justin

          On Wed, May 16, 2018 at 1:41 PM, Yelitza Parra <[email-masked]> wrote:

            Hello,

            This is the ticket for the DB migrations https://redmine.cakedc.com/issues/23163, the estimate for it is ~18-22 hours. 
            Let me know if it is approved this estimate, we could start today with the migration.

            Thank you,

            On Wed, May 16, 2018 at 10:46 AM, Yelitza Parra <[email-masked]> wrote:

              Hi guys, good news, we were able to restore the database in an Enterprise SqlServer we installed. 

              We will prepare the estimate for you and let you know.

              Thank you,

              On Wed, May 16, 2018 at 9:34 AM, Yelitza Parra <[email-masked]> wrote:

                Hello guys, 

                We have been trying to restore the database into our local environments, and in an azure server we set up, with no luck.

                The issue with our local environments was because of the size of the dump (25G), we have installed SQL Express and there is a limitation to 4G.

                Then in the azure server the only way to restore a database is with bacpac files and the file provide is a .bak.

                if you guys could provide a smaller dump would be useful, with that we could provide the estimate for migration task, including figuring out an option for 25G dump.

                Sorry for the inconvenience, 

                -- 

                     Yelitza Parra
                      Project Manager and CakePHP Developer

                     
                       
                      Cake Development Corporation 
                      1785 East Sahara Avenue, 
                      Suite 490-423 Las Vegas, Nevada 89104

                      +1 (702) 425-5085

                      cakedc.com 

              -- 

                   Yelitza Parra
                    Project Manager and CakePHP Developer

                   
                     
                    Cake Development Corporation 
                    1785 East Sahara Avenue, 
                    Suite 490-423 Las Vegas, Nevada 89104

                    +1 (702) 425-5085

                    cakedc.com 

            -- 

                 Yelitza Parra
                  Project Manager and CakePHP Developer

                 
                   
                  Cake Development Corporation 
                  1785 East Sahara Avenue, 
                  Suite 490-423 Las Vegas, Nevada 89104

                  +1 (702) 425-5085

                  cakedc.com 

            This email may contain material that is confidential, privileged and/or work product for the sole use of the intended recipient.  Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited.  If you are not the intended recipient, please contact the sender and delete all copies.

            Cake Development Corporation.

        -- 

             Yelitza Parra
              Project Manager and CakePHP Developer

             
               
              Cake Development Corporation 
              1785 East Sahara Avenue, 
              Suite 490-423 Las Vegas, Nevada 89104

              +1 (702) 425-5085

              cakedc.com 

        This email may contain material that is confidential, privileged and/or work product for the sole use of the intended recipient.  Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited.  If you are not the intended recipient, please contact the sender and delete all copies.

        Cake Development Corporation.

    -- 

         Yelitza Parra
          Project Manager and CakePHP Developer

         
           
          Cake Development Corporation 
          1785 East Sahara Avenue, 
          Suite 490-423 Las Vegas, Nevada 89104

          +1 (702) 425-5085

          cakedc.com 

    This email may contain material that is confidential, privileged and/or work product for the sole use of the intended recipient.  Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited.  If you are not the intended recipient, please contact the sender and delete all copies.

    Cake Development Corporation.

-- 

     Yelitza Parra
      Project Manager and CakePHP Developer

     
       
      Cake Development Corporation 
      1785 East Sahara Avenue, 
      Suite 490-423 Las Vegas, Nevada 89104

      +1 (702) 425-5085

      cakedc.com 

This email may contain material that is confidential, privileged and/or work product for the sole use of the intended recipient.  Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited.  If you are not the intended recipient, please contact the sender and delete all copies.

Cake Development Corporation.