Link to home
Start Free TrialLog in
Avatar of Philip Wright
Philip Wright

asked on

Visual Studio (neophite) Create an app with data stored separately

I'm looking into Visual Studio Community to get a start in Visual Studio programming (and to see if I like it). I believe I can create a standalone executable app in this free version. Am I correct?
My app will require database tables. Does Visual Studio come with a database server? What is the default in Visual Studio?
Do I need to obtain a separate data server like MySQL or MariaDB or something?
SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Philip Wright
Philip Wright

ASKER

Thanks, LVL54 AND LVL64! That answers my question perfectly. I'm going to mark this question as resolved but I'll have to toss a coin to decide who gets 'Best Solution'!
One more quick question, which is a better free database server to play on?
MS SQL Server 2017 Express Edition
MySQL (now owned by Oracle, I understand)
MariaDB (I'm a big supporter of open-source development, so this one 'feels' right)

Can I easily move data from one SQL server type to another if I decide to change?

This is not actually as silly a question to ask as it might sound to a seasoned database expert.
I've recently been doing a project in Microsoft Access 2013. I was updating tables from the old FoxPro DBFs into a separate import database (accdb) and sorting everything.  But I was NOT able to pull the data from the import database into identical tables in my main data database. My approach was to clear the data system tables to empty and then fill them with the imported data.
Everything appeared to work fine. But when I checked the data, the data system tables had not actually been updated! The tables always contained the original data, even though I'd wiped all the relevant tables to empty. I first used simple built-in routines in Access. Then when that didn't work I wrote my own (fairly simple).
In NEITHER case were the final tables updated.
There was undoubtedly a reason for this, something to do with data integrity I was missing, perhaps. But it was surprising, nonetheless.
It wasn't essential, however, so I just scrapped the idea. I never really researched into the 'why'.
I already left a closing comment. Oh, I'm glad to see you both got equal points awarded!
Thanks again, Ryan and Fernando!
Hi Philip;

To your question,
Which is a better free database server to play on?
Well I can't give you and answer to this question because I have not used many different DB systems I have used MS SQL Server and MySQL and I like them both and seem to work well.

To your question
Can I easily move data from one SQL server type to another if I decide to change?
I can not speak to other platforms but MS SQL Server has a tool called SQL Server Import and Export Wizard that can do some of what you need.

Hope that helps.