Subject: Re: Database dump
From: Yelitza Parra <[email-masked]>
To: Michael B <[email-masked]>
Cc: Justin Fata <[email-masked]>, CakeDC Development Team <[email-masked]>, Destavioun Carr <[email-masked]>, Jeremy Leonard <[email-masked]>
Date: Thu, 24 May 2018 09:58:17 -0500

Good morning, the link to the meeting https://zoom.us/j/991774545

On Tue, May 22, 2018 at 10:35 AM, Michael B <[email-masked]> wrote:

> 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 <[email-masked]>
> *Sent:* Tuesday, May 22, 2018 9:58 AM
> *To:* Justin Fata <[email-masked]>
> *Cc:* CakeDC Development Team <[email-masked]> ; Destavioun Carr
> <[email-masked]> ; Jeremy Leonard <[email-masked]> ; Michael
> B <[email-masked]>
> *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
>>>>>>>>> <https://twitter.com/> <https://github.com/CakeDC>
>>>>>>>>> <https://www.facebook.com/Cake.Development.Corporation/>
>>>>>>>>> <https://www.linkedin.com/>
>>>>>>>>> <http://www.cakedc.com/> <http://www.cakephp.org/>
>>>>>>>>>
>>>>>>>>> Cake Development Corporation
>>>>>>>>> 1785 East Sahara Avenue,
>>>>>>>>> <https://maps.google.com/?q=1785+East+Sahara+Avenue,%C2%A0+Suite+490&entry=gmail&source=g>
>>>>>>>>> Suite 490
>>>>>>>>> <https://maps.google.com/?q=1785+East+Sahara+Avenue,%C2%A0+Suite+490&entry=gmail&source=g>-423
>>>>>>>>> Las Vegas, Nevada 89104
>>>>>>>>>
>>>>>>>>> +1 (702) 425-5085
>>>>>>>>> cakedc.com <http://www.cakedc.com/>
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>>
>>>>>>>> Yelitza Parra
>>>>>>>> Project Manager and CakePHP Developer
>>>>>>>> <https://twitter.com/> <https://github.com/CakeDC>
>>>>>>>> <https://www.facebook.com/Cake.Development.Corporation/>
>>>>>>>> <https://www.linkedin.com/>
>>>>>>>> <http://www.cakedc.com/> <http://www.cakephp.org/>
>>>>>>>>
>>>>>>>> Cake Development Corporation
>>>>>>>> 1785 East Sahara Avenue,
>>>>>>>> <https://maps.google.com/?q=1785+East+Sahara+Avenue,%C2%A0+Suite+490&entry=gmail&source=g>
>>>>>>>> Suite 490
>>>>>>>> <https://maps.google.com/?q=1785+East+Sahara+Avenue,%C2%A0+Suite+490&entry=gmail&source=g>-423
>>>>>>>> Las Vegas, Nevada 89104
>>>>>>>>
>>>>>>>> +1 (702) 425-5085
>>>>>>>> cakedc.com <http://www.cakedc.com/>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>>
>>>>>>> Yelitza Parra
>>>>>>> Project Manager and CakePHP Developer
>>>>>>> <https://twitter.com/> <https://github.com/CakeDC>
>>>>>>> <https://www.facebook.com/Cake.Development.Corporation/>
>>>>>>> <https://www.linkedin.com/>
>>>>>>> <http://www.cakedc.com/> <http://www.cakephp.org/>
>>>>>>>
>>>>>>> Cake Development Corporation
>>>>>>> 1785 East Sahara Avenue,
>>>>>>> <https://maps.google.com/?q=1785+East+Sahara+Avenue,%C2%A0+Suite+490&entry=gmail&source=g>
>>>>>>> Suite 490
>>>>>>> <https://maps.google.com/?q=1785+East+Sahara+Avenue,%C2%A0+Suite+490&entry=gmail&source=g>-423
>>>>>>> Las Vegas, Nevada 89104
>>>>>>>
>>>>>>> +1 (702) 425-5085
>>>>>>> cakedc.com <http://www.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
>>>>> <https://twitter.com/> <https://github.com/CakeDC>
>>>>> <https://www.facebook.com/Cake.Development.Corporation/>
>>>>> <https://www.linkedin.com/>
>>>>> <http://www.cakedc.com/> <http://www.cakephp.org/>
>>>>>
>>>>> Cake Development Corporation
>>>>> 1785 East Sahara Avenue,
>>>>> <https://maps.google.com/?q=1785+East+Sahara+Avenue,%C2%A0+Suite+490&entry=gmail&source=g>
>>>>> Suite 490
>>>>> <https://maps.google.com/?q=1785+East+Sahara+Avenue,%C2%A0+Suite+490&entry=gmail&source=g>-423
>>>>> Las Vegas, Nevada 89104
>>>>>
>>>>> +1 (702) 425-5085
>>>>> cakedc.com <http://www.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
>>> <https://twitter.com/> <https://github.com/CakeDC>
>>> <https://www.facebook.com/Cake.Development.Corporation/>
>>> <https://www.linkedin.com/>
>>> <http://www.cakedc.com/> <http://www.cakephp.org/>
>>>
>>> Cake Development Corporation
>>> 1785 East Sahara Avenue,
>>> <https://maps.google.com/?q=1785+East+Sahara+Avenue,%C2%A0+Suite+490&entry=gmail&source=g>
>>> Suite 490
>>> <https://maps.google.com/?q=1785+East+Sahara+Avenue,%C2%A0+Suite+490&entry=gmail&source=g>-423
>>> Las Vegas, Nevada 89104
>>>
>>> +1 (702) 425-5085
>>> cakedc.com <http://www.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
> <https://twitter.com/> <https://github.com/CakeDC>
> <https://www.facebook.com/Cake.Development.Corporation/>
> <https://www.linkedin.com/>
> <http://www.cakedc.com/> <http://www.cakephp.org/>
>
> Cake Development Corporation
> 1785 East Sahara Avenue,
> <https://maps.google.com/?q=1785+East+Sahara+Avenue,+Suite+490&entry=gmail&source=g>
>
> Suite 490-423 Las Vegas, Nevada 89104
>
> +1 (702) 425-5085
> cakedc.com <http://www.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
<https://twitter.com/> <https://github.com/CakeDC>
<https://www.facebook.com/Cake.Development.Corporation/>
<https://www.linkedin.com/>
<http://www.cakedc.com/> <http://www.cakephp.org/>

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

+1 (702) 425-5085
cakedc.com <http://www.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.