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

preview_player
Показать описание
Microsoft SQL Server Database Project in Visual Studio 2022( Getting Started)
Microsoft SQL Server is a relational database management system. Its primary function is retrieving and storing data as requested by other applications
With Visual Studio 2022 you can create a new database project and import a database schema from an existing database SQL script file. You can then invoke some visual designer tools, transact SQL editor, table designer, which is available for connected database development to make changes to the offline database project and also publish changes back to the production database.
Рекомендации по теме
Комментарии
Автор

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

engrrosetem
Автор

Thanks for the Video. easy to follow. Just got started with writing a winforms app that started as a text based config with output to text files then added database support. I was doing all my "create table" logic in SQL Server Management Studio with saved SQL files, but this is way better as I can put my project under source control in Github. Maybe I should have already know this stuff.

MythivarYaslana
Автор

Excellent! Just what I needed to get me started. Thanks for the upload 🙂

ace--x
Автор

Thank you so much for such an informative video.

salman
Автор

Thanks, that was what i was looking for.

CaribouDataScience
Автор

This video is very useful 👌
Thanks 😊

powerbackknowledge
Автор

finally a video that helped mi a looot! Thanks

bxounzf
Автор

There is a error while trying to import and connect database saying that to enable trust server certificate by reviewing ssl and certificate configuration
How to correct this?

bhuvaneshwarib
Автор

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

andresaguilar
Автор

How to manage deployment change into different environment like local, dev, qa and prod?

dilipmevada
Автор

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.

hasanmougharbel
Автор

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

kennywilliamm
Автор

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

knightmarerip
Автор

what should I do if i want to create a new table like in 3:40 but there isn't a option to that?

grukoub
Автор

when i add table mine says failed to retrieve server version

rbalgecira
Автор

what do i do if importing didnt bring the table but "security" and "server objects" instead? edit: nvm i figured it out

spiritretro
Автор

hi can i ask about mu problem that said

The connection properties object must be of type SqlConnectionProperties or OleDBSqlConnectionPropertiies

protobelt
Автор

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.

dennistucker
Автор

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

bryanbruner
Автор

please let me know that it can be connect with a program c++?

-angtoanquoc