February 27, 2015 at 8:34 am
Just wondering, I have a SQL Developer version installed on my laptop and I'm considering upsizing someone's database from Access to SQL Server because I really want some stability for the company's backend database. The database won't grow very fast, so I'm not worried about size. I want SQL Server more for stability/backups. They don't add tons of records on a daily basis, but losing their data would be devastating.
I know I can use Express and Ola Halllengren's backup scripts...
can I emulate Express with 2012 Developer, or do I have to install Express alongside Developer?
Thanks!
Pieter
February 27, 2015 at 8:40 am
pietlinden (2/27/2015)
can I emulate Express with 2012 Developer, or do I have to install Express alongside Developer?
If you are asking if you can use developer edition to creation the table structures and sql scripts, procs, views etc, then use you can use Developer edition.
If you are trying to emulate size restrictions etc, then you would need to think outside the box.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 27, 2015 at 8:48 am
I was trying to do the latter. Not the size restrictions etc. The idea was to upsize the Access back end to SQL Server (Express) and then use Ola Hallengren's backup scripts and call them from Windows Scheduler. Just trying to avoid the possibility that the Access DB folds up and self-destructs and the client calls me asking what to do.
The size restriction isn't the issue. There won't be a ton of data in the database. I just need the recoverability.
February 27, 2015 at 9:07 am
Outside the size restrictions and absence of agent, you should be fine using Developer edition to build your Express db. Bear in mind, that you won't be able to build in any enterprise features (think Standard edition SQL Server while developing).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 27, 2015 at 9:10 am
There's pretty much no way I would need them. The company is tiny (like 10 people), and they don't generate data like it's going out of style. I could do it all in Access, but I don't like the risk of complete data loss when the database blows up.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply