update database sql server

~~redbull2905~~ · 07/03/2018, 06:08

How do I update the database sql server I edit something and they ask me to update it please tell me how to do and if possible no useless answer. Tell me precisely what to do

~~ImTheReal~~ · 07/03/2018, 06:50

Step 1: Delelte all Database content (All Tables, if theres a error just keep going, you are able to delete them)

Step 2: Open the Console on VS, and type in: Update-Database -Verbose

Step 3: Parsing

erixor · 07/03/2018, 07:32

Quote:

Originally Posted by ImTheReal

Step 1: Delelte all Database content (All Tables, if theres a error just keep going, you are able to delete them)

Step 2: Open the Console on VS, and type in: Update-Database -Verbose

Step 3: Parsing

really ? xD

_____________

If you edited something in the code, then just use the packet manager console (tools => NuGet Package manager => Packet Manager Console), select the DAL.EF project, and use these 2 commands:

- Add-Migration Aphrodite
- Update-Database

~~redbull2905~~ · 07/03/2018, 07:53

I opened ssms I typed aws rds modify-db-instance
**** --db-instance-identifier <mydbinstance> ^
**** --engine-version <11.00.6020.0.v1> ^
**** --option-group-name <default: sqlserver-se-11-00> ^
**** --db-parameter-group-name <default.sqlserver-se-11.0> ^
**** --allow-major-version-upgrade ^
**** --no-apply-immediately and then I made debug and it worked
--no-apply-immediately

erixor · 07/03/2018, 18:04

Why in the hell would you use something like that ?

I just told you how to do in my previous comment.

~~redbull2905~~ · 07/03/2018, 20:29

well we do not care as long as it worked for me

Blowa · 07/03/2018, 20:49

Quote:

Originally Posted by ImTheReal

Step 1: Delelte all Database content (All Tables, if theres a error just keep going, you are able to delete them)

Step 2: Open the Console on VS, and type in: Update-Database -Verbose

Step 3: Parsing

You must be right, we should delete everything when it does not work as it should.

0Lucifer0 · 07/03/2018, 22:11

Quote:

Originally Posted by erixor

Why in the hell would you use something like that ?

I just told you how to do in my previous comment.

It seems it was not his question : his question was how to update the software sql server... this is sad to know that someone can’t even write a correct question or update a software.
This is again more sad when you do a good answer and he answer “I don’t care”

Saber none · 07/03/2018, 22:40

Quote:

Originally Posted by 0Lucifer0

It seems it was not his question : his question was how to update the software sql server... this is sad to know that someone can’t even write a correct question or update a software.
This is again more sad when you do a good answer and he answer “I don’t care”

Quote:

Originally Posted by val77

You must be right, we should delete everything when it does not work as it should.

I know you both are great developers, but in this case i cant understand you, isnt it actually a simple answer to his more or less complicated and not accurate question? There is no need to flame him for that, cant you just give him an answer to this question ...?

0Lucifer0 · 07/03/2018, 22:51

I don’t flame anyone... just tell to Erixor that is answer was good but that the question was not accurate at all. Because yes the erixor solution to add a migration is THE way to change the database.
Moreover it seems the question was how to update sql server on aws... without aws precision no one would find the answer he was expecting

Blowa · 07/03/2018, 23:46

Quote:

Originally Posted by mix0067@

I know you both are great developers, but in this case i cant understand you, isnt it actually a simple answer to his more or less complicated and not accurate question? There is no need to flame him for that, cant you just give him an answer to this question ...?

I'm not flaming the author of the thread nor anyone, just tells that it's a smart choice to delete EVERY datas when something does not work.

~~ImTheReal~~ · 07/05/2018, 12:50

Quote:

Originally Posted by val77

I'm not flaming the author of the thread nor anyone, just tells that it's a smart choice to delete EVERY datas when something does not work.

That was ironic, cuz when someone is too stupid to update the database they should just delete everything they had.
OpenNos is so simple, but instead of just trying out themself, they beg for help with every single error they have

~~redbull2905~~ · 07/05/2018, 17:00

It depends I know much more stuff than before but I do not know any more so I necessarily ask but hey when there are boloss like blowa who answer in the end it is useless