Results 1 to 3 of 3

Thread: How portable is SQL Server? Want DB on laptop, but want to easily back up or move.

  1. #1

    Thread Starter
    Member
    Join Date
    Sep 2017
    Location
    UK, France, Belgium, Ireland
    Posts
    34

    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?

  2. #2
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    110,299

    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.

  3. #3

    Thread Starter
    Member
    Join Date
    Sep 2017
    Location
    UK, France, Belgium, Ireland
    Posts
    34

    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
  •  



Click Here to Expand Forum to Full Width