database sql server scripts

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.
This thread is closed to new posts. You must sign in to post in the forums.
11/8/2013 5:22:48 AM
Gravatar
Total Posts 4

database sql server scripts

I'm using vs2013 framework 4.5.1 sql server 2012, on widows 8.1

 

I can't install the database with the web installer... doesn't seem to find the sql server. there must be a collection of .sql files I can just execute against my database. Where can I get those from please?

 

thanks

11/8/2013 6:54:12 AM
Gravatar
Total Posts 18439

Re: database sql server scripts

you don't need to run scripts manually.

All platform installer does is rename the file user.config.sample to user.config in the root of the site and it sets the connection string in that file.

do that yourself then just visit  /Setup/Default.aspx  and it will run the scripts

see also manual installation

11/8/2013 6:57:02 AM
Gravatar
Total Posts 18439

Re: database sql server scripts

also platform installer does not install source code and the package it does install is not for use with VS

See Understanding the Difference Between source code and deployment files and Avoid Forking the Code

11/8/2013 8:26:13 AM
Gravatar
Total Posts 4

Re: database sql server scripts

thanks joe,

haha... yes of course I realise the difference between deployment code and source code, just thought using the web installer might setup my database for me and save some time. I found all the config files in the setup folder though, just thought there might be some .sql versions, something a little more hands on for developers to play with. Having said that I can just change the extensions.

I am seriously modifying the code to use EF with the stored procedures and ditching all the other database options. I didn't want to have to run the setup bit. I will probably ditch the UI bits too and replace with MVC, but for now I just want to get the db objects loaded.

Thanks anyway

11/8/2013 8:30:32 AM
Gravatar
Total Posts 18439

Re: database sql server scripts

ok, just so you know I don't offer any support for people who decide to fork the code

 

11/8/2013 8:50:20 AM
Gravatar
Total Posts 4

Re: database sql server scripts

no... understood and wouldn't expect any support with my dev of course. I appreciate your rationale for advising not doing so, but forking it is very much on my mind. If any good comes of it I'll give you the source as a possible start point for next generation mojo. Got this skin idea of using bootstrap as the layout guide, all ajax through web api and routing through MVC.

I was thinking of using nop as my start point but can't abide di and ioc... just seems wrong. mojo seems fairly well set out and easy to follow and has all the e-commerce assemblies I need.

Thanks

11/8/2013 10:27:16 AM
Gravatar
Total Posts 2247

Re: database sql server scripts

You're seriously going to spend a lot more time renaming files and running through them manually than just running setup. You can easily use the setup to create your DB and then ditch it, if that's your plan. So you know the Setup is really de-coupled from the rest of mojo so you really don't need to get rid of it to go the MVC path.

Thanks,
Joe D.

11/8/2013 10:46:04 AM
Gravatar
Total Posts 4

Re: database sql server scripts

quite right...that's exactly what I did. I just ran the setup in iis, separately from vs. the db is fully loaded now.

thanks for that

Stu

 

You must sign in to post in the forums. This thread is closed to new posts.