[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 455
  • Last Modified:

Make a local copy of a MSSQL DB

I've been running our website off a MSSQL database, running off a server in the same place as the HTTP server.

When testing new features, our local copy of the database accesses the remote database server. This causes two problems:
1. It's very slow due to everything being sent over the internet
2. It makes testing new data features difficult as they have to use the live DB

Therefore, I'd like to make a local copy. We don't have any licenses of SQL Server and don't really want to run it either. I'd prefer MSSQL Express 2005 as its a lot lighter. Is there any way to move the current structure from the remote DB to a MSSQL Express DB?
0
OliWarner
Asked:
OliWarner
5 Solutions
 
rbrookerCommented:
you should be able to take a backup and restore it to the 'lite' version, although, the lite version has no gui, it is all command line.
you might also run into size restrictions, i think mssql express is limited to 4gb
0
 
OliWarnerAuthor Commented:
4gig isn't an issue... its nearer 20meg =)

just getting a DB backup now so I'll post back then
0
 
Kevin3NFCommented:
best is to set up the same version and SP/hotfix level to ensure true compatibility.  What version is the live server?
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
OliWarnerAuthor Commented:
Well as I said, I don't want to deploy an entire server for the sake of a 20meg DB. So I'd rather use Express as its a lot lighter on its toes.
0
 
t2weiCommented:
There is a free version of SQL server:MSDE (Microsoft SQL Server Desktop Engine),  you can download from http://www.microsoft.com/downloads/details.aspx?displaylang=zh-cn&FamilyID=413744D1-A0BC-479F-BAFA-E4B278EB9147

I do not know the version of your live DB (SQL server 2000 or SQL server 2005), But I think both versions are available in MSDE

Also If you have a licence for SQL server on your live server, you can install the tools for the SQL server on your PC, and you can use the tools to link to your MSDE too.
0
 
MrNeticCommented:

The best recomendation to achive your results, is to backup the Prod Database, and restore it to MSDE ( 2000 Version ).

You could also use MSSQLSERVER 2005 Express Editon, but you should leave de Database Compatibily Mode = 80.

Best Regards,

Paulo Condeça.
0
 
hclgroupCommented:
rbrooker

MS SQL Server Express Edition does have a GUI Management Tool
0
 
rbrookerCommented:
excellent :)

i have used msde 2000, thought that express would be similar...
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now