Hi all,
I am starting a new project based on NC v2.6. I Installed it locally connecting to a local database.
What would be the best way to move this database to production server once I complete development? There is no database currently in the production server. (this is a fresh, new project).
Thanks!
Best way to move database to production
- 125
- 795
- 2/3/2011
- United States
Kman wrote:
Hi Kman,
Thanks for your answer.
Yes, there is another detail. The site will be hosted on shared-hosting environment and I am not sure, I will be able to do the restore. I remember I had some problems with that in the past.
Any other recommendation?
Thanks again!
Backup the database on your local => Restore from backup on production.
Would that work for you or are there more details here?
Would that work for you or are there more details here?
Hi Kman,
Thanks for your answer.
Yes, there is another detail. The site will be hosted on shared-hosting environment and I am not sure, I will be able to do the restore. I remember I had some problems with that in the past.
Any other recommendation?
Thanks again!
- 20
- 198
- 9/7/2009
- United States
LAM-ECOM wrote:
Yes, there is another detail. The site will be hosted on shared-hosting environment and I am not sure, I will be able to do the restore. I remember I had some problems with that in the past.
Any other recommendation?
Most host will allow one of two methods to initially setup your database. One, they will take a backup and do the restore for you. Two, they may take a detached .mdf and also attach it to an empty database setup on your server.
About the only other methods I know of is to start with an empty database at your host then transfer the structure and data via third party tools. This can be done if you have the data edition of Visual Studio or Red Gate tools has two good programs to do this. First is SQL Compare and second is SQL Data compare. The last one I did I used the Red Gate tools. I think you can get a thirty day trial on these if you want to give it a go against an empty database at your host.
Also, you can let nop create the empty database structure and then use SQL Data Compare to get your data in there.
Good luck,
Kman
Yes, there is another detail. The site will be hosted on shared-hosting environment and I am not sure, I will be able to do the restore. I remember I had some problems with that in the past.
Any other recommendation?
Most host will allow one of two methods to initially setup your database. One, they will take a backup and do the restore for you. Two, they may take a detached .mdf and also attach it to an empty database setup on your server.
About the only other methods I know of is to start with an empty database at your host then transfer the structure and data via third party tools. This can be done if you have the data edition of Visual Studio or Red Gate tools has two good programs to do this. First is SQL Compare and second is SQL Data compare. The last one I did I used the Red Gate tools. I think you can get a thirty day trial on these if you want to give it a go against an empty database at your host.
Also, you can let nop create the empty database structure and then use SQL Data Compare to get your data in there.
Good luck,
Kman
- 125
- 795
- 2/3/2011
- United States
Kman wrote:
Yes, there is another detail. The site will be hosted on shared-hosting environment and I am not sure, I will be able to do the restore. I remember I had some problems with that in the past.
Any other recommendation?
Most host will allow one of two methods to initially setup your database. One, they will take a backup and do the restore for you. Two, they may take a detached .mdf and also attach it to an empty database setup on your server.
About the only other methods I know of is to start with an empty database at your host then transfer the structure and data via third party tools. This can be done if you have the data edition of Visual Studio or Red Gate tools has two good programs to do this. First is SQL Compare and second is SQL Data compare. The last one I did I used the Red Gate tools. I think you can get a thirty day trial on these if you want to give it a go against an empty database at your host.
Also, you can let nop create the empty database structure and then use SQL Data Compare to get your data in there.
Good luck,
Kman
I was wondering if I could "re-install" NC, selecting an empty DB on the Server, and then simply transfer the data I might have locally. Would that work?
Yes, there is another detail. The site will be hosted on shared-hosting environment and I am not sure, I will be able to do the restore. I remember I had some problems with that in the past.
Any other recommendation?
Most host will allow one of two methods to initially setup your database. One, they will take a backup and do the restore for you. Two, they may take a detached .mdf and also attach it to an empty database setup on your server.
About the only other methods I know of is to start with an empty database at your host then transfer the structure and data via third party tools. This can be done if you have the data edition of Visual Studio or Red Gate tools has two good programs to do this. First is SQL Compare and second is SQL Data compare. The last one I did I used the Red Gate tools. I think you can get a thirty day trial on these if you want to give it a go against an empty database at your host.
Also, you can let nop create the empty database structure and then use SQL Data Compare to get your data in there.
Good luck,
Kman
I was wondering if I could "re-install" NC, selecting an empty DB on the Server, and then simply transfer the data I might have locally. Would that work?