Quantcast

Maximum PC

It is currently Mon Sep 22, 2014 2:24 pm

All times are UTC - 8 hours




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Question on reading DB's with SQL Server Express 2008/2010
PostPosted: Sat Feb 11, 2012 2:15 pm 
Willamette
Willamette

Joined: Tue Feb 01, 2005 12:17 pm
Posts: 1479
At work, we use MS SQL Server 2008 (Standard) which is used in part with our Product Data Management System to manage the file system on our server (we use the SolidWorks Enterprise PDM system, which makes use of SQL Server for it's database).

There are times when I need to manually parse the database (not on a daily basis. but often enough to make it a bit of a burden right now), Anyway, I want to be able to download the DB, for example on the weekend, and parse and do what I need to on my laptop at home. Can I read and edit the DB using SQL Server Express 2008/2010 on my laptop, or will I need to get the exact same version (or at least, not an Express version) of SQL Server to do this?

At this point, I'd like to NOT have to get SQL Server (a paid copy) for my laptop, because of the cost. So, I'm looking for alternatives first, and then will buy it if I have to (the company I work for, will buy it).

Secondly, does the Express version have a system like the SQL Management Studio with it, or is the express version merely to HOST databases, not edit them directly?


Top
  Profile  
 
 Post subject: Re: Question on reading DB's with SQL Server Express 2008/20
PostPosted: Thu Feb 16, 2012 12:11 pm 
Million Club - 5 Plus*
Million Club - 5 Plus*
User avatar

Joined: Sun Sep 12, 2004 6:37 pm
Posts: 4745
Location: In the monkey's litterbox
You should be able to attach a copy of the database from the Standard edition as long as it fits within the file size limit (4GB or 10GB if the version is 2008 R2).

If you need to edit the database and have the changes persist to the live DB though, you'd be better off working against the server database over a VPN with the management studio included in the SQL Server Express (w/tools) download. The tools included with the Express edition do work against full version DBs on remote machines with some limitations


Top
  Profile  
 
 Post subject: Re: Question on reading DB's with SQL Server Express 2008/20
PostPosted: Thu Feb 23, 2012 7:00 am 
Bitchin' Fast 3D Z8000
Bitchin' Fast 3D Z8000
User avatar

Joined: Mon Jun 14, 2004 4:04 pm
Posts: 985
Location: Earth
cbassett01 wrote:
At work, we use MS SQL Server 2008 (Standard) which is used in part with our Product Data Management System to manage the file system on our server (we use the SolidWorks Enterprise PDM system, which makes use of SQL Server for it's database).

There are times when I need to manually parse the database (not on a daily basis. but often enough to make it a bit of a burden right now), Anyway, I want to be able to download the DB, for example on the weekend, and parse and do what I need to on my laptop at home. Can I read and edit the DB using SQL Server Express 2008/2010 on my laptop, or will I need to get the exact same version (or at least, not an Express version) of SQL Server to do this?

At this point, I'd like to NOT have to get SQL Server (a paid copy) for my laptop, because of the cost. So, I'm looking for alternatives first, and then will buy it if I have to (the company I work for, will buy it).

Secondly, does the Express version have a system like the SQL Management Studio with it, or is the express version merely to HOST databases, not edit them directly?


The Express versions have limits:
- 10GB max DB size
- 1 CPU
- 4GB RAM

Standard can go up to 524PB (yes, petabytes) and is only restricted in memory and other features. I use Express a lot, but for your doings, make sure that the .bak files don't go over 10GB. If they do, then you'll need to shoot to something paid. Express also has SQL Management Studio, which is a separate download w/ Web Platform Installer.


Top
  Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC - 8 hours


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group