Wrong Database
This is a database question, rather than a Sitefinity question.
I have a site on a development database that Sitefinity (in the DataConfig.config) points to one database, but all my custom application data (web.config connection string) points to a different database. I'd like to move the SF data into my other database. Any suggestions on the best approach to do this?
From Visual Studio 2010, I was thinking about comparing the schema on the two and then comparing data.
Eric
Hello Eric,
Thank you for using our services.
You can achieve this using the Import Data wizard from SQL Management Studio. What you have to do is to import all data from your Sitefinity database to the other one and then change the connection string in the DataConfig file. You can find some steps on how to use this tool here.
Regards,
Radoslav Georgiev
the Telerik team