I am a novice with Wappler (obviously with web apps building also…) and I am in a stage that I need some instructions IF SOMEONE HAS TIME to help me.
I am working on my first 2 projects (web apps, php handled).
I had set the local server and Database connection for it, and everything goes well.
For the one project (that I haven’t used any database data yet) I had to upload the files in order to have a look on how it works so far (I created a subdomain for that reason).
So, after uploading the files manually I realized that I have to create a separate database connection for the remote target.
I did it and I saw that the remote’s server database is empty.
I have to copy the database’s structure/data from my local to remote server in order to work continue work and develop on my project?
Can the Local & Remote server databases be synchronized?
Or I have done something wrong?
I am sorry for taking your time with novice’s questions…
The one project that I uploaded is a small one with no special needs, but the other one is a very serious one.
If somebody can give me a hand would be much appreciated!
Thank you mzucker for your quick respond!
As I explained, I have already created Remote DB connection and uploaded my necessary files to server.
The question was how I keep on working on development (local) target and every database structure change I make locally and update my remote target database whenever I am sure of the correct result of my coding.
So, I experimented and created a test table in my Local target and by switching to Remote target, inside my DB connection I noticed that inside the **changes** dropdown menu, the change a made in Local target is listed also and in my Remote target and by right clicking it I get the “APPLY THIS CHANGE” option.
I guess this is the way of working around on Local/Remote database structure synchronization in Wappler (and of course it makes absolutely sense to me).
So, I will wait for a while to see if something else will be suggested.
Thanks mzucker
If you have different and local and remote databases, you can indeed easy synchronize their schema by just switching to remote target and apply the schema changes. Or you can use the new publishing manager that does that for you.
Do note that only schema changes are applied, database data stays separate.
Thanks George!
Publishing manager is a great tool but I avoided clicking that button cause I thought that everything would be done automatically.
Thanks George, thanks Wappler
You are all doing great job guys and I’m surprised of this community’s fast and effective responds.