# Add a new database in Ignition Using Button

**URL:** <https://forum.inductiveautomation.com/t/add-a-new-database-in-ignition-using-button/59192>\
**Category:** Ignition\
**Created:** [May 4, 2022, 7:04am UTC](https://forum.inductiveautomation.com/t/add-a-new-database-in-ignition-using-button/59192 "2022-05-04T07:04:48Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Prabhat\_Giri](https://avatars.discourse-cdn.com/v4/letter/p/7993a0/32.png) [@Prabhat\_Giri](https://forum.inductiveautomation.com/u/Prabhat_Giri)\
**Post date:** [May 4, 2022, 7:04am UTC](https://forum.inductiveautomation.com/t/add-a-new-database-in-ignition-using-button/59192/1 "2022-05-04T07:04:48Z")

</div>

Hello,  
I am looking to add a database in Ignition using - ‘system.db.addDatasource’ system function using the code examples given in the site. Here I am not able to connect my jdbc driver i,e of Microsoft SQLServer to my code and getting error as JDBC Driver not found.

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [May 4, 2022, 7:12am UTC](https://forum.inductiveautomation.com/t/add-a-new-database-in-ignition-using-button/59192/2 "2022-05-04T07:12:20Z")

</div>

> [@Prabhat\_Giri](#):
>
> system.db.addDatasource

Just to be clear, that doesn't add a database, it "Adds a new database **connection** in Ignition". The database must already exist.

[system.db.addDatasource - Ignition User Manual 8.1 - Ignition Documentation](https://docs.inductiveautomation.com/display/DOC81/system.db.addDatasource).

---

<div class="post-metadata">

**Author:** ![Prabhat\_Giri](https://avatars.discourse-cdn.com/v4/letter/p/7993a0/32.png) [@Prabhat\_Giri](https://forum.inductiveautomation.com/u/Prabhat_Giri)\
**Post date:** [May 4, 2022, 7:21am UTC](https://forum.inductiveautomation.com/t/add-a-new-database-in-ignition-using-button/59192/3 "2022-05-04T07:21:23Z")

</div>

Is there a way to add database in Ignition?

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [May 4, 2022, 8:14am UTC](https://forum.inductiveautomation.com/t/add-a-new-database-in-ignition-using-button/59192/4 "2022-05-04T08:14:46Z")

</div>

As far as I know, no.  
You would normally create the database using your SQL management software - Microsoft SQL Management Studio for you, I think.

---

<div class="post-metadata">

**Author:** ![jonathan.taylor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jonathan.taylor/32/4048_2.png) [@jonathan.taylor](https://forum.inductiveautomation.com/u/jonathan.taylor)\
**Post date:** [May 4, 2022, 8:21am UTC](https://forum.inductiveautomation.com/t/add-a-new-database-in-ignition-using-button/59192/5 "2022-05-04T08:21:11Z")

</div>

You should be able to by using a query - [SQL CREATE/ALTER/DROP SCHEMA - w3resource](https://www.w3resource.com/sql/sql-basic/create-schema.php)

---

<div class="post-metadata">

**Author:** ![Prabhat\_Giri](https://avatars.discourse-cdn.com/v4/letter/p/7993a0/32.png) [@Prabhat\_Giri](https://forum.inductiveautomation.com/u/Prabhat_Giri)\
**Post date:** [May 4, 2022, 12:13pm UTC](https://forum.inductiveautomation.com/t/add-a-new-database-in-ignition-using-button/59192/6 "2022-05-04T12:13:20Z")

</div>

Thanks,  
Will Check on adding new database connection.