July 31, 2008 at 6:07 pm
Ok.
I have a current example and a thought and need guidance....
We have 50 SQL DB's 1 for each company......
To me this is a maintance nightmare.I think this was done to alow a backup of CompanyABC data to allow single restore on server..
I have the data re-strucutred to use 1 massive db....
Here is the issue
Lets say CompanyABC which is now a GUID 1111-111-111-111 as example in the single model......
In SQL 2000 how do I do a partial backup of only that companies data in the single DB model???
Performance?????
August 1, 2008 at 11:21 am
Dumping to a textfile?
3th party tools?
August 1, 2008 at 12:17 pm
allenrlewis (7/31/2008)
Ok.I have the data re-strucutred to use 1 massive db....
Performance?????
So, now, 50 Companys' in one DB? and each one has a table in that 'massive db', right??
If so, you can use 3rd party tools, like, LiteSpeed, SQLsafe, etc.
Those can do table-level restore.
August 1, 2008 at 12:22 pm
I've worked with data in both ways and I'd argue you've created a maintenance headache. Separating out data, restoring a customer, moving data if a customer needs their own server because they've grown larger, it's all a problem the way you do it. You've also created risk. If there's an issue in your database, then ALL your customers have issues. If you have separate databases, chances are one is affected.
If you have separate tables for each customer, I'd argue you haven't really made things easier by putting in one database. Backup, integrity checks, etc. are all easy to automate across lots of databases.
If you have combined things into a few tables, you need custom scripts to export the data.
August 1, 2008 at 1:05 pm
No,I use guid to sepeartae a company specific data.....inside all tables not one for each company
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply