System and method for registering and deploying stored procedures and triggers into a device database

• US 20050114827A1
• Filed: 11/21/2003
• Published: 05/26/2005
• Est. Priority Date: 11/21/2003
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Smith, Scott, Lane, Carlton
• Granted Patent: US 7,539,971 B2
• Time in Patent Office: Days
• US Class Current: 717/101
• CPC Class Codes: G06F 8/20 Software design

Abstract

A development tool enables a device database to be created, managed, and deployed to a device as part of the a device project. The device database may have an installation property which provides logic for installing the device database at the device. Additionally, stored procedures and triggers may be registered with the device database. The registered stored procedures and triggers may be embedded in the device database and deployed to the device along with the device database.

Claims

1. A method for deploying a stored procedure to a device, the method comprising:

embedding the stored procedure into a device database;

registering the stored procedure with the device database; and

deploying the device database to the device.

2. The method of claim 1, further comprising compiling code for the stored procedure.

3. The method of claim 1, comprising embedding a trigger into the device database.

4. The method of claim 1, further comprising reserving data storage capacity for the stored procedure within the device database.

5. The method of claim 1, further comprising:

determining whether the stored procedure has been previously embedded on the database; and

if the stored procedure has been previously embedded, then removing the previously embedded stored procedure.

6. The method of claim 1, comprising deploying the device database to the device as part of a main device project.

7. The method of claim 1, comprising deploying the device database to the device as part of a device setup project.

8. The method of claim 1, comprising registering the stored procedure with the device database at the device.

9. A method for deploying a stored procedure to a device, the method comprising:

providing an interface that enables a user to create a data project, the data project being associated with a device database and having an assembly comprising the stored procedure;

embedding the assembly within the device database;

registering the assembly with the device database; and

deploying the device database to the device.

10. The method of claim 9, further comprising providing an interface displaying a view of each stored procedure associated with the device database.

11. The method of claim 10, further comprising providing an interface enabling a stored procedure associated with the device database to be added to the data project.

12. The method of claim 10, further comprising providing an interface enabling a stored procedure associated with the device database to be deleted from the data project.

13. The method of claim 9, further comprising providing an interface displaying a view of properties of each stored procedure associated with the device database.

14. The method of claim 9, further comprising compiling code for the stored procedure.

15. The method of claim 9, comprising embedding the assembly within the device database, the assembly comprising a trigger.

16. The method of claim 9, further comprising:

determining whether the assembly has been previously embedded on the device database; and

if the assembly has been previously embedded, then removing the previously embedded assembly.

17. The method of claim 9, comprising deploying the device database to the device as part of a main device project.

18. The method of claim 9, comprising deploying the device database to the device as part of a device setup project.

19. The method of claim 9, comprising registering the stored procedure with the device database at the device

20. A computer readable medium for deploying a stored procedure to a device, the computer readable medium comprising computer executable instructions for:

embedding the stored procedure into a device database;

registering the stored procedure with the device database; and

deploying the device database to the device.

21. The computer readable medium of claim 20, further comprising computer executable instructions for compiling code for the stored procedure.

22. The computer readable medium of claim 20, comprising computer executable instructions for embedding a trigger into the device database.

23. The computer readable medium of claim 20, further comprising computer executable instructions for reserving data storage capacity for the stored procedure within the device database.

24. The computer readable medium of claim 20, further comprising computer executable instructions for:

determining whether the stored procedure has been previously embedded on the database; and

if the stored procedure has been previously embedded, then removing the previously embedded stored procedure.

25. The computer readable medium of claim 20, comprising computer executable instructions for deploying the device database to the device as part of a main device project.

26. The computer readable medium of claim 20, comprising computer executable instructions for deploying the device database to the device as part of a device setup project.

27. The computer readable medium of claim 20, comprising computer executable instructions for registering the stored procedure with the device database at the device.

28. A computer readable medium for deploying a stored procedure to a device, the computer readable medium comprising computer executable instructions for:

providing an interface that enables a user to create a data project, the data project being associated with a device database and having an assembly comprising the stored procedure;

embedding the assembly within the device database;

registering the assembly with the device database; and

deploying the device database to the device.

29. The computer readable medium of claim 28, further comprising computer executable instructions for providing an interface displaying a view of each stored procedure associated with the device database.

30. The computer readable medium of claim 29, further comprising computer executable instructions for providing an interface enabling a stored procedure associated with the device database to be added to the data project.

31. The computer readable medium of claim 29, further comprising computer executable instructions for providing an interface enabling a stored procedure associated with the device database to be deleted from the data project.

32. The computer readable medium of claim 28, further comprising computer executable instructions for providing an interface displaying a view of properties of each stored procedure associated with the device database.

33. The computer readable medium of claim 28, further comprising computer executable instructions for compiling code for the stored procedure.

34. The computer readable medium of claim 28, comprising computer executable instructions for embedding the assembly within the device database, the assembly comprising a trigger.

35. The computer readable medium of claim 28, further comprising computer executable instructions for:

determining whether the assembly has been previously embedded on the device database; and

if the assembly has been previously embedded, then removing the previously embedded assembly.

36. The computer readable medium of claim 28, comprising computer executable instructions for deploying the device database to the device as part of a main device project.

37. The computer readable medium of claim 28, comprising computer executable instructions for deploying the device database to the device as part of a device setup project.

38. The computer readable medium of claim 28, comprising computer executable instructions for registering the stored procedure with the device database at the device.