New LunarPages subscriber here with the Windows package. Trying to figure out what my workflow will be. Would appreciate it if some of you more experienced types could chime in and tell me if this sounds about right.
Developing asp.net 2.0 and 3.5 in Visual Studio 2008. Preferred datasource is MS SQL Server connected to the app with a Dataset, TableAdapters, and objectdatasources. Based on some of the posts in this forum, it sounds like these are the steps to take:
- Download and install SQL Server Express
- Create a database, tables, Roles schema, and user
- Set up the connection string in web.config to point to the local database
- In VS2008, create and test a dataset based on the tables in this database
- Create whatever pages are needed
- Use SQL Server Express to create a .bak copy of the database
- Use Plesk to create an MS SQL database and user named the same as the local version
- Use myLittleAdmin to "restore" the .bak version to LunarPages' server
- Change the connectionstring in web.config to point to the LunarPages SQL server
- Publish the website app and files to some (?) folder on my site
- Verify data access is working as it should
Does this sound about right for a high level overview? Any tips or suggestions or links to tutorials that would help would be appreciated.
Thanks,
John