Microsoft SQL Server Database Project in Visual Studio 2022( Getting Started)

Microsoft SQL Server Database Project in Visual Studio 2022( Getting Started)

Hacked

2 года назад

188,656 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

Knightmare RIP
Knightmare RIP - 07.09.2023 15:40

Is it just me or is the audio really low? Content is good though.

Ответить
Andrés Aguilar
Andrés Aguilar - 31.08.2023 00:03

Great video, the only thing is that if the project can be used for Oracle.

Ответить
James Dudley
James Dudley - 17.08.2023 01:51

could you record your voice louder its very hard to here you then again I might be going def.

Ответить
exAlexey
exAlexey - 29.07.2023 23:17

Comfortable) But how to create Database Project for MySQL 8.0 ?

Ответить
Nel Pat
Nel Pat - 01.07.2023 19:50

finally a video that helped mi a looot! Thanks

Ответить
Bryan Bruner
Bryan Bruner - 07.06.2023 05:04

Man, i'm using the 2022 version but some options you are chosing just don't apper to me. Can you help me?

Ответить
Muzamil Zaman
Muzamil Zaman - 21.05.2023 19:14

Now we won't have to install Microsoft sql server separately is it true?

Ответить
Ceastem Nov
Ceastem Nov - 08.05.2023 20:12

thank you for this video, one of my problems has been solved... my learning of sql in asp has come to light.

Ответить
Scrittyrow
Scrittyrow - 04.05.2023 17:16

cant hear anything!

Ответить
Powerback Knowledge
Powerback Knowledge - 09.03.2023 14:58

This video is very useful 👌
Thanks 😊

Ответить
nitesh sonawane
nitesh sonawane - 26.02.2023 09:52

Great Video, easy to learn.

Ответить
אסף לוץ
אסף לוץ - 17.02.2023 21:44

Youre the man! <3

Ответить
Jens Gyldenkærne Jensen
Jens Gyldenkærne Jensen - 16.02.2023 18:37

Creating the table directly in the database and then importing it to the Visual Studio project makes the table appear in a nice folder structure (schema name/Tables/table name as shown in the video). I'm surprised to see that there apparently is no simple way of making getting this folder structure directly from Visual Studio. If I for instance would add a new view in the database, I would have to create the dbo/Views folder manually and then place the view there to keep an organized folder structure. And stuff like deployment scripts have no standard designated folder to be placed in. As a long time SQL Server developer - but a newcomer to the Visual Studio database projects - this seems like an annoying setback.
I've googled in search for extensions or templates that mitigate the lack of folder structure in the Visual Studio database project - but has so far found nothing apart from manual descriptions for creating the folder structure - and the option to import an readymade database and work from there.

If you or any other readers have better suggestions, please let me know. I have a simple template db made with one table, one view, one function and one stored procedure - so my current workaround is to import the template db and then delete the template objects but keep the folders. But it would be so much better if VS could simply create a best practice folder structure when I create a new database project (or offer to add the specific folder when I add a new item that "belongs" in a designated folder).

Ответить
William Kenny
William Kenny - 09.02.2023 19:44

Thanks for this great tutorial. Why is it necessary to publish the database as in the latter part of the tutorial?

Ответить
yulieth ramirez
yulieth ramirez - 07.02.2023 00:35

Hello, how can I do the process in the opposite way, a change made in the database is reflected in the visual project? How do I publish the change in the opposite way, taking into account that the project is already created, thanks

Ответить
suchdoge muchwow
suchdoge muchwow - 19.01.2023 17:21

1. learn english
2. tell at least what the hell are you doing instead of just clicking buttons and saying what theres written on the f***** buttons, we can read

Ответить
Dennis Tucker
Dennis Tucker - 21.12.2022 07:33

I was able to import from visual studio. I then went into the database, added a table, went back to visual studio, right clicked project, but the database was now greyed out.

Ответить
Hasan Mougharbel
Hasan Mougharbel - 30.07.2022 19:21

Hey there,keep up the great work in your channel.
I have only a general enquiry as a newbie sql learner.
Could i channel shopify live data into an sql application?(This should be an application developed for a company of 50 employees mainly for the sake of generating reports and analytics))
Is this an easy process to undertake as a sql beginner? What should i keep in mind
and what are the tools or softwares that i should work with right from the beginning.
For notice, I made my mind to work with microsoft sql server, also our company has a dedicated server.
Thanks for taking care of my enquiry.

Ответить
Mert
Mert - 16.06.2022 10:47

you talk like a roadman

Ответить