-
Sep 24th, 2017, 08:07 AM
#1
Thread Starter
Member
How portable is SQL Server? Want DB on laptop, but want to easily back up or move.
I have this MS Access database on my laptop, and am developing a VB.NET app as a front end. I'm quite happy about the DB being on my C: drive -- it's a single-user system (the user being me), plus I don't have to worry about security or costs or connection difficulties if it's hosted on the Internet.
The nice thing about Access is its database can be a single file, hence easy to back up or move as and when necessary. But I dislike Access, plus I would rather like to use the stored procedures that SQL Server offers.
What's involved in backing up a SQL Server DB to a thumb drive, and then restoring to another machine if my laptop should die?
-
Sep 24th, 2017, 08:58 AM
#2
Re: How portable is SQL Server? Want DB on laptop, but want to easily back up or move
If you have SQL Server Management Studio installed, backing up and restoring is a few clicks. If you don't, it's running a commandline in a console window.
-
Sep 24th, 2017, 10:49 AM
#3
Thread Starter
Member
Re: How portable is SQL Server? Want DB on laptop, but want to easily back up or move
Thanks, will investigate.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|