Showing posts with label scripts. Show all posts
Showing posts with label scripts. Show all posts

Friday, March 30, 2012

Laws against copying the whole database structure and scripts.

Hi,

I would like to know if there are laws in any state that prohibits anyone from using someone else's database structure and stored procedures. I would like to think that if someone's else got hold of my database and use it and sell a product that uses the structure, will there be a legal basis to sue that person or company?

I know that this sounds a little bit crazy but I want some light regarding this matter.

ThanksDon't let anyone into your database, use passwords to protect it.
Grant rights as appropriate. If you want people to get to a database through application but not directly to a database hash people passwords before login so they wouldnt really know their passwords. Never grant windows authentication.

I never heard of such law. If you let person into your database and let them view everything they probably can copy it.
You have to have patent for your work to protect your copy rights by law.

Good Luck.|||

Quote:

Originally Posted by lihard

Hi,

I would like to know if there are laws in any state that prohibits anyone from using someone else's database structure and stored procedures. I would like to think that if someone's else got hold of my database and use it and sell a product that uses the structure, will there be a legal basis to sue that person or company?

I know that this sounds a little bit crazy but I want some light regarding this matter.

Thanks



In my experience (and I am not a lawyer so don't quote me on it. If you need that go see one) the principles of copyright law demand that you can prove 'uniqueness' of a product entity to you. To have a script that creates a table of shall we say people in which there might be firstname, surname and so on, in itself would be impossible to prove as 'your' copyright because it is so generic.

If however over a thousand scripts comprising one system if it could be shown that the total number when taken together as a 'whole' shows uniqueness of 'the system' then you may have a case.

The protection of copyright (as distinct from patent) is invoked the minute an object is created by its author it does not require any other action, no court action, patent or anything else from my understanding.

Practically speaking you would need to ensure that 'uniqueness' is in your favour as the author and that this can be 'demonstrated' to a third party/external body (ie a court). Evidentially speaking this could be something as little as posting a document or other crucial proof of its existence, at a point in time, back to yourself on the day the object was created.

The process is always going to be adversarial... the outcome of which would rely on independant adjudication to determine who is the so called 'winner' no doubt from a very costly prosecution or defence of an 'action'

Regards

Jim

Monday, March 12, 2012

Last Anonymous Pull Subscription Question....I PROMISE

How can I setup an anonymous pull subscription, using the sp_ scripts for the pull subscription & pull agent, for NO SYNC?
Jude
Jude, to make life simple for your self is there anyway you can restore the publishing database to the subscriber and do a no-sync?
This will make life much easier for you.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JLS" <jlshoop@.hotmail.com> wrote in message news:%23%23RCIYP$FHA.264@.tk2msftngp13.phx.gbl...
How can I setup an anonymous pull subscription, using the sp_ scripts for the pull subscription & pull agent, for NO SYNC?
Jude
|||I'm not following what you are telling me to do. Both servers already have this db, the one in the domain is pushing to the db on the DMZ, and now I need to pull 2 tables from this same db from the db on the DMZ.
I am trying to accomplish this with a Anonymous Pull Subscription, but I don't know how to set it up for no sync.
Can you give me more explicit details of what you are saying would make life simpler for me?
JUDE
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message news:ekZ$dCQ$FHA.2392@.TK2MSFTNGP09.phx.gbl...
Jude, to make life simple for your self is there anyway you can restore the publishing database to the subscriber and do a no-sync?
This will make life much easier for you.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JLS" <jlshoop@.hotmail.com> wrote in message news:%23%23RCIYP$FHA.264@.tk2msftngp13.phx.gbl...
How can I setup an anonymous pull subscription, using the sp_ scripts for the pull subscription & pull agent, for NO SYNC?
Jude