On Tue, May 27, 2014 at 1:57 PM, < [email protected]> wrote:
> According to http://en.wikipedia.org/wiki/SQL_Server_Express, it's 10GB > for the DATABASE. Still, I doubt I'd ever hit that with all my tables!!!! > So given that...does SQL Server Express hold any advantage over MariaDB > for me? Idk...but I'm happy with what I've got so no reason at this time > to change. > > ---------------- > You know that you can add numerous db into the mix that each have the 10Gig limit. Thus you could make a DW in one db that can update as fast as you want from production. Put in a TEST db where you can attempt to make all schema changes in place and not screw the pooch accidentally. If you have a lot of transaction you can add more production databases and combine schema to put all Order based tables into OrdersProd. InvoicesProd could hold just the AR data. There has to be a limit of how many db can be placed into an instance but I don't know the number now. You could identify one way replication by enabling log shipping. i don't think the wizards are set to function in Express but the code they write can be run and you suddenly have log shipping -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMYLn6DtaGCZAoV3adda0h-wc1DPzvVJR-2UTkb=ffvp...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
