Page 1 of 1

Load SQL database to internet

Posted: Fri Mar 25, 2022 5:11 am
by crash

After many years of using aspmaker and access database, I’ve converted my access database into sql database as was suggested. I’ve got it working with asp.net maker.

Previously I would simply transfer all the files to my online site including the access database. Now it seems different. Sorry I’m new to this and new to sql.

How do I transfer my sql database to link with my online project?

I have created a sql backup file. Is this what I must transfer.

Is there a help file somewhere explaining this ?

I’ve built my project and now that I need to load it online I’m stuck.

Please point me in the right direction.

Thanks very much
New to all this


Re: Load sql to internet

Posted: Fri Mar 25, 2022 6:53 am
by MichaelG

You should publish the project. Read Generate Settings -> Publish below for more information:
https://aspnetmaker.dev/docs/#/generatesetup.html


Re: Load sql to internet

Posted: Fri Mar 25, 2022 10:22 am
by crash

Thanks, I have now generated all files and used the publish option. The files generated to my PC
I have loaded the files into a folder on my internet server...I still get the same problem 404 error.

Do I need to transfer anything else... like the sql or does this transfer with the project file.


Re: Load sql to internet

Posted: Sat Mar 26, 2022 3:57 am
by crash

I have now loaded my project onto my online server... but now all I see is a page with directory files.

All my other projects using aspmaker work fine.. they use an access database and it's IIS

How do I get this to work... I cannot find anything that says how I must load an sql database to my online site.

Thanks for any help


Re: Load sql to internet

Posted: Sun Mar 27, 2022 6:28 am
by MichaelG

You should publish the project. Read Generate Settings -> Publish below for more information:
https://aspnetmaker.dev/docs/#/generatesetup.html

Refer note 2 from the article above and read the articles (Host ASP.NET Core on Windows with IIS / Publish an ASP.NET Core app to IIS). Also make sure that you have installed the ASP.NET Core Module/Hosting Bundle in your server.

To restore backup of your database on your web server, read Restore a Database Backup Using SSMS.


Re: Load SQL database to internet

Posted: Fri Apr 01, 2022 9:31 am
by crash

Thanks.. do I still need to load my sql database separately.. or is my database in the publish folder ?


Re: Load SQL database to internet

Posted: Sat Apr 02, 2022 7:06 am
by MichaelG

The publish folder contains the codes only. You should create and restore your database to your remote server.


Re: Load SQL database to internet

Posted: Sat Apr 02, 2022 10:41 am
by crash

Thanks.. where do I load my database to and how will my codes find it.
Thanks


Re: Load sql to internet

Posted: Sat Apr 02, 2022 5:03 pm
by MichaelG

MichaelG wrote:

To restore backup of your database on your web server, read Restore a Database Backup Using SSMS.