# Creating a ASP.NET version of OpenEMR

**URL:** <https://community.open-emr.org/t/creating-a-asp-net-version-of-openemr/4883>\
**Category:** OpenEMR Development\
**Created:** [September 22, 2009, 8:20pm UTC](https://community.open-emr.org/t/creating-a-asp-net-version-of-openemr/4883 "2009-09-22T20:20:58Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [September 22, 2009, 8:20pm UTC](https://community.open-emr.org/t/creating-a-asp-net-version-of-openemr/4883/1 "2009-09-22T20:20:58Z")

</div>

**[jarrette](https://sourceforge.net/u/jarrette/)** wrote on [Tuesday, September 22, 2009](https://sourceforge.net/p/openemr/discussion/202506/thread/11dc93e9/#7c59):

Hey guys, I’m very interested in getting the database file separately as my first step in converting this project for our .NET environment.&nbsp; I’d like to convert the HIPAA compliant tables to SQL Server and then get cracking on the code.&nbsp; Is there a way to get the database file by itself?

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [September 22, 2009, 9:37pm UTC](https://community.open-emr.org/t/creating-a-asp-net-version-of-openemr/4883/2 "2009-09-22T21:37:10Z")

</div>

**[sunsetsystems](https://sourceforge.net/u/sunsetsystems/)** wrote on [Tuesday, September 22, 2009](https://sourceforge.net/p/openemr/discussion/202506/thread/11dc93e9/#c5c7):

What database file is that?

I’d suggest &quot;extending&quot; rather than &quot;converting&quot; the database interface.&nbsp; I.e. abstract the database layer so it is not specific to MySQL, but still works with it as well as your preferred server and potentially other SQL servers in the future.&nbsp; That way the project will want to include your work and not leave you out in the cold.

This is a nontrivial task, but would be a very nice improvement.

Rod&nbsp;  
([http://www.sunsetsystems.com/)](http://www.sunsetsystems.com/%29)

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [September 22, 2009, 11:11pm UTC](https://community.open-emr.org/t/creating-a-asp-net-version-of-openemr/4883/3 "2009-09-22T23:11:44Z")

</div>

**[jarrette](https://sourceforge.net/u/jarrette/)** wrote on [Tuesday, September 22, 2009](https://sourceforge.net/p/openemr/discussion/202506/thread/11dc93e9/#0c08):

I want to get to the schema, get the tables, the actual database itself.

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [September 22, 2009, 11:22pm UTC](https://community.open-emr.org/t/creating-a-asp-net-version-of-openemr/4883/4 "2009-09-22T23:22:41Z")

</div>

**[sunsetsystems](https://sourceforge.net/u/sunsetsystems/)** wrote on [Tuesday, September 22, 2009](https://sourceforge.net/p/openemr/discussion/202506/thread/11dc93e9/#ccd6):

That would be sql/database.sql in the distribution.

Rod&nbsp;  
([http://www.sunsetsystems.com/)](http://www.sunsetsystems.com/%29)

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [September 23, 2009, 3:35am UTC](https://community.open-emr.org/t/creating-a-asp-net-version-of-openemr/4883/5 "2009-09-23T03:35:04Z")

</div>

**[jarrette](https://sourceforge.net/u/jarrette/)** wrote on [Wednesday, September 23, 2009](https://sourceforge.net/p/openemr/discussion/202506/thread/11dc93e9/#55f2):

OK, I had the &quot;appliance&quot; and not the actual app, was confusing the hell out of me.&nbsp; Thanks for the help hehe.

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [September 23, 2009, 5:59am UTC](https://community.open-emr.org/t/creating-a-asp-net-version-of-openemr/4883/6 "2009-09-23T05:59:29Z")

</div>

**[bradymiller](https://sourceforge.net/u/bradymiller/)** wrote on [Wednesday, September 23, 2009](https://sourceforge.net/p/openemr/discussion/202506/thread/11dc93e9/#cd03):

hey,

Check out the project website homepage at [oemr.org](http://oemr.org), especially the downloads page, to see explanations of all the packages.

-brady

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [September 23, 2009, 2:42pm UTC](https://community.open-emr.org/t/creating-a-asp-net-version-of-openemr/4883/7 "2009-09-23T14:42:36Z")

</div>

**[jarrette](https://sourceforge.net/u/jarrette/)** wrote on [Wednesday, September 23, 2009](https://sourceforge.net/p/openemr/discussion/202506/thread/11dc93e9/#4493):

I’ve got the SQL file, now the trick is getting that script to work for SQL Server 2008.&nbsp; Is there a better way then manually going through each create table and rewriting the script.&nbsp;

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [September 23, 2009, 3:10pm UTC](https://community.open-emr.org/t/creating-a-asp-net-version-of-openemr/4883/8 "2009-09-23T15:10:13Z")

</div>

**[jarrette](https://sourceforge.net/u/jarrette/)** wrote on [Wednesday, September 23, 2009](https://sourceforge.net/p/openemr/discussion/202506/thread/11dc93e9/#201f):

sheesh, I’m new to mysql, i’m using the standard client.&nbsp; It looks like the client&nbsp; removes whitespace so all the comment lines from the database.sql file get mashed into the statements.&nbsp; Going through each statement one by one and copying/pasting into the client.&nbsp; What a pain.

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [September 23, 2009, 3:34pm UTC](https://community.open-emr.org/t/creating-a-asp-net-version-of-openemr/4883/9 "2009-09-23T15:34:17Z")

</div>

**[jarrette](https://sourceforge.net/u/jarrette/)** wrote on [Wednesday, September 23, 2009](https://sourceforge.net/p/openemr/discussion/202506/thread/11dc93e9/#bda1):

OK I downloaded the mysql gui and used the adminstrator to &quot;restore&quot; the sql db, now I’ll just convert the db over to sql server.&nbsp; Sorry for this thread being so annoying 🙂

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [September 23, 2009, 3:50pm UTC](https://community.open-emr.org/t/creating-a-asp-net-version-of-openemr/4883/10 "2009-09-23T15:50:14Z")

</div>

**[josephenochs](https://sourceforge.net/u/josephenochs/)** wrote on [Wednesday, September 23, 2009](https://sourceforge.net/p/openemr/discussion/202506/thread/11dc93e9/#f373):

On the contrary, I’m finding it rather exciting. It will be interesting to see how the mysql functions, triggers, etc… transition to microsoft sql.

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [September 23, 2009, 4:38pm UTC](https://community.open-emr.org/t/creating-a-asp-net-version-of-openemr/4883/11 "2009-09-23T16:38:20Z")

</div>

**[jarrette](https://sourceforge.net/u/jarrette/)** wrote on [Wednesday, September 23, 2009](https://sourceforge.net/p/openemr/discussion/202506/thread/11dc93e9/#ffc0):

are all the functions and triggers I will need in the database.sql file?

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [September 23, 2009, 4:42pm UTC](https://community.open-emr.org/t/creating-a-asp-net-version-of-openemr/4883/12 "2009-09-23T16:42:15Z")

</div>

**[sunsetsystems](https://sourceforge.net/u/sunsetsystems/)** wrote on [Wednesday, September 23, 2009](https://sourceforge.net/p/openemr/discussion/202506/thread/11dc93e9/#0d3e):

There are no functions or triggers.

Rod&nbsp;  
([http://www.sunsetsystems.com/)](http://www.sunsetsystems.com/%29)

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [September 23, 2009, 4:47pm UTC](https://community.open-emr.org/t/creating-a-asp-net-version-of-openemr/4883/13 "2009-09-23T16:47:45Z")

</div>

**[bradymiller](https://sourceforge.net/u/bradymiller/)** wrote on [Wednesday, September 23, 2009](https://sourceforge.net/p/openemr/discussion/202506/thread/11dc93e9/#caa6):

hey,

In case you want to support language translations:

The database.sql file contains everything but the language translation tables (three tables); they are empty dummy tables in database.sql. The sql file that contains the filled language translation tables (these are brought in during the installation setup.php script) can be found here:

[http://openemr.cvs.sourceforge.net/viewvc/](http://openemr.cvs.sourceforge.net/viewvc/)\*checkout\*/openemr/openemr/contrib/util/language\_translations/currentLanguage\_utf8.sql?revision=1.11.2.6

-brady

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [September 23, 2009, 5:08pm UTC](https://community.open-emr.org/t/creating-a-asp-net-version-of-openemr/4883/14 "2009-09-23T17:08:59Z")

</div>

**[josephenochs](https://sourceforge.net/u/josephenochs/)** wrote on [Wednesday, September 23, 2009](https://sourceforge.net/p/openemr/discussion/202506/thread/11dc93e9/#d039):

Thanks Rod:

I’m also assuming that there are no stored procedures?

Meaning that all logic other than primary/foriegn key relationships are handled in php code in the web pages…

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [September 23, 2009, 5:38pm UTC](https://community.open-emr.org/t/creating-a-asp-net-version-of-openemr/4883/15 "2009-09-23T17:38:03Z")

</div>

**[sunsetsystems](https://sourceforge.net/u/sunsetsystems/)** wrote on [Wednesday, September 23, 2009](https://sourceforge.net/p/openemr/discussion/202506/thread/11dc93e9/#fc6d):

Yes that’s correct.&nbsp; No stored procedures.&nbsp; Even most foreign key relationships are enforced only on the PHP side, which is an area that could really use improvement.

Rod&nbsp;  
([http://www.sunsetsystems.com/)](http://www.sunsetsystems.com/%29)