Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  Database Design and Application Architecture  How to Automate Changes to My DAL and BAL

Author  Topic  river Starting Member 1 Post Posted - 2007-01-19 : 20:41:35 I am using SQL 2005, running on Windows XP Home Edition. I have Windows XP SP2. . I created the database with Visual Studio 2005 but am now using Visual Web Developer Express. The Data, Business and Presentation layers run beautifully on my local machine with no glitches in functionality except the SMTP for password recovery which is not at issue right now. The problem is I created the database first then went to Web Administration tool to create the membership and stuff. So now I have the .mdf file that I created plus the ASPNETDB.MDF file. The problem is that my host will not let me upload both files to their server. I positively dread the idea of having to manually recreate my tables in the ASPNETDB database which will mena manually recreating all my table adapters and all the object data sources and searching my cs files for all references to the table adapters so I can point them to the right database. Tech support at my host told me I could also run aspnet_regsql.exe and make it point to ther server but Windows XP won't give me access to that folder in the command line and the wizard can't connect to the server and I don't know if I want to use this option anyway. Please tell me is there an way to automate the changes to my table adapters and stuff when I move the tables to the ASPNETDB?