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

• US 7,539,971 B2
• Filed: 11/21/2003
• Issued: 05/26/2009
• Est. Priority Date: 11/21/2003
• Status: Expired due to Fees

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Smith, Scott, Lane, Carlton
• Primary Examiner(s): Dam; Tuan Q
• Assistant Examiner(s): TECKLU, ISAAC TUKU
• Application Number:
  US10/718,951
• Publication Number:
  US 20050114827A1
• Time in Patent Office: 2,013 Days
• Field of Search: 717/130, 717/173, 717/174, 702/193, 709/223, 707/1, 707/3, 707/10
• US Class Current: 717/103
• 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 at least one stored procedure to a device, the method comprising:

generating a data project and a device database associated with an installation property within a solution;

associating the data project with the device database;

adding the at least one stored procedure to the data project, the at least one stored procedure comprising a precompiled set of one or more statements for accessing data in a database, one of the stored procedures being a trigger that is executed in response to a data modification operation;

receiving a request to build the solution, and, responsive to the request;

automatically embedding each stored procedure in the data project into the device database, wherein embedding each stored procedure comprises;

determining whether the at least one stored procedure has been previously embedded in the device database; and

if the at least one stored procedure has been previously embedded, then removing the previously embedded stored procedure; and

automatically registering each stored procedure in the data project with the device database;

deploying the device database with the at least one embedded stored procedure as a single unit to the device; and

installing the device database with the at least one embedded stored procedure on the device according to the installation property, wherein installing the device database on the device according to the installation property comprises overwriting an existing device database that was previously installed on the device if the installation property comprises an always overwrite setting, overwriting the existing device database if the installation property comprises an overwrite if different setting and the deployed device database is different from the existing device database, and installing the deployed device database on the device if the installation property comprises a never overwrite setting and no existing device database was previously installed on the device.

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

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

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

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

6. The method of claim 1, comprising registering the at least one stored procedure with the device database at the device after the device database is deployed with the at least one embedded stored procedure to the device.

7. A method for deploying at least one stored procedure comprising a precompiled set of one or more statements for accessing data in a database to a device, the method comprising;

providing a first interface that enables a data project containing the at least one stored procedure and a trigger that is executed in response to a data modification operation and a device project containing a device database to be generated within a solution, the first interface further enabling the stored procedure and the trigger to be associated with the device database, the device database associated with an installation property comprising one of an always overwrite setting, an overwrite if different setting, and a never overwrite setting;

providing a second interface that enables the at least one stored procedure and the trigger to be added to an assembly within the data project;

receiving a request to build the solution, and, responsive to the request;

automatically embedding the assembly within the device database; and

automatically registering the assembly with the device database;

deploying the device database with the embedded assembly as a single unit to the device; and

installing the deployed device database on the device according to the installation property, wherein installing the deployed device database on the device according to the installation property comprises overwriting an existing device database that was previously installed on the device if the installation property comprises the always overwrite setting, overwriting the existing device database if the installation property comprises the overwrite if different setting and the deployed device database is different from the existing device database, and installing the deployed device database on the device if the installation property comprises the never overwrite setting and no existing device database was previously installed on the device.

8. The method of claim 7, further comprising providing an interface displaying a view of the at least one stored procedure.

9. The method of claim 8, wherein the second interface enables the at least one stored procedure to be deleted from the assembly.

10. The method of claim 7, further comprising providing an interface displaying a view of properties of the at least one stored procedure.

11. The method of claim 7, further comprising compiling code for the at least one stored procedure.

12. The method of claim 7, comprising embedding the assembly within the device database, the assembly comprising the trigger.

13. The method of claim 7, further comprising:

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

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

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

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

16. The method of claim 7, comprising registering the at least one stored procedure with the device database at the device after the device database has been deployed with the embedded assembly to the device.

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

generating a data project and a device database associated with an installation property within a solution;

associating the data project with the device database;

adding the at least one stored procedure to the data project, the at least one stored procedure comprising a precompiled set of one or more statements for accessing data in a database, one of the stored procedures being a trigger that is executed in response to a data modification operation;

receiving a request to build the solution, and, responsive to the request;

automatically embedding each stored procedure in the data project into the device database, wherein embedding each stored procedure comprises;

determining whether the at least one stored procedure has been previously embedded in the device database; and

if the at least one stored procedure has been previously embedded, then removing the previously embedded procedure; and

automatically registering each stored procedure in the data project with the device database;

deploying the device database with the at least one embedded stored procedure as a single unit to the device; and

installing the device database with the at least one embedded stored procedure on the device according to the installation property, wherein installing the device database on the device according to the installation property comprises overwriting an existing device database that was previously installed on the device if the installation property comprises an always overwrite setting, overwriting the existing device database if the installation property comprises an overwrite if different setting and the deployed device database is different from the existing device database, and installing the deployed device database on the device if the installation property comprises a never overwrite setting and no existing device database was previously installed on the device.

18. The computer readable storage medium of claim 17, further comprising computer executable instructions for compiling code for the at least one stored procedure.

19. The computer readable storage medium of claim 17, further comprising computer executable instructions for reserving data storage capacity for the at least one stored procedure within the device database.

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

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

22. The computer readable storage medium of claim 17, comprising computer executable instructions for registering the at least one stored procedure with the device database at the device after the device database has been deployed with the at least one embedded stored procedure to the device.

23. A computer readable storage medium for deploying at least one stored procedure comprising a precompiled set of one or more statements for accessing data in a database to a device, the computer readable storage medium comprising computer executable instructions for:

providing a first interface that enables a data project containing the at least one stored procedure and a trigger that is executed in response to a data modification operation and a device project containing a device database to be generated within a solution, the first interface further enabling the stored procedure and the trigger to be associated with the device database, the device database associated with an installation property comprising one of an always overwrite setting, an overwrite if different setting, and a never overwrite setting;

providing a second interface that enables the at least one stored procedure and the trigger to be added to an assembly within the data project;

receiving a request to build the solution, and, responsive to the request;

automatically embedding the assembly within the device database; and

automatically registering the assembly with the device database;

deploying the device database with the embedded assembly as a single unit to the device; and

installing the deployed device database on the device according to the installation property, wherein installing the deployed device database on the device according to the installation property comprises overwriting an existing device database that was previously installed on the device if the installation property comprises the always overwrite setting, overwriting the existing device database if the installation property comprises the overwrite if different setting and the deployed device database is different from the existing device database, and installing the deployed device database on the device if the installation property comprises the never overwrite setting and no existing device database was previously installed on the device.

24. The computer readable storage medium of claim 23, further comprising computer executable instructions for providing an interface displaying a view of the at least one stored procedure.

25. The computer readable storage medium of claim 24, wherein the second interface enables the at least one stored procedure to be deleted from the assembly.

26. The computer readable storage medium of claim 23, further comprising computer executable instructions for providing an interface displaying a view of properties of the at least one stored procedure.

27. The computer readable storage medium of claim 23, further comprising computer executable instructions for compiling code for the at least one stored procedure.

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

29. The computer readable storage medium of claim 23, further comprising computer executable instructions for:

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

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

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

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

32. The computer readable storage medium of claim 23, comprising computer executable instructions for registering the at least one stored procedure with the device database at the device after the database has been deployed with the embedded assembly to the device.