Guest Maexi Posted March 15, 2008 Posted March 15, 2008 Hi, I developed a Web Application with Visual Web Developer and SQL Server Express Edition on my local PC. Now I rented a Virtual Windows Server 2003 (from 1&1) and want transfer the files from my PC to the server. It's the first time I am doing this. Actually I do not know how to get the database transfered and what to consider with the connection string. Do I have to install SQL Server Express Edition on the Windows Server 2003 ? Or do I just have to copy the mdf-file from my local PC to a certain folder on the server ? What do I have to consider with the connection string that I used in my applications (webconfig-file) ? Many thanks in advance ! Maexi
Guest Dave Patrick Posted March 16, 2008 Posted March 16, 2008 Re: SQL Server Express on Virtual Windows Server 2003 No, that wouldn't work. You'll need an instance of SQL Server to host your MDF/LDF database files. You'll probably want to create a full database backup then restore it to the new server. -- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "Maexi" wrote: > > Hi, > > I developed a Web Application with Visual Web Developer and SQL Server > Express Edition on my local PC. Now I rented a Virtual Windows Server 2003 > (from 1&1) and want transfer the files from my PC to the server. > It's the first time I am doing this. > Actually I do not know how to get the database transfered and what to > consider with the connection string. > Do I have to install SQL Server Express Edition on the Windows Server 2003 > ? > Or do I just have to copy the mdf-file from my local PC to a certain > folder > on the server ? > What do I have to consider with the connection string that I used in my > applications (webconfig-file) ? > > Many thanks in advance ! > > Maexi
Guest Maexi Posted March 16, 2008 Posted March 16, 2008 Re: SQL Server Express on Virtual Windows Server 2003 Thanks Dave. I created a backup my database and transfered the file (database.bak) to my server. But how will I be able to restore it there ? The Server is a Windows Server 2003, Standard x64 Edition. It doesn't allow me to install SQL Server Express Edition -> not correct OP. Markus "Dave Patrick" wrote: > No, that wouldn't work. You'll need an instance of SQL Server to host your > MDF/LDF database files. You'll probably want to create a full database > backup then restore it to the new server. > > > > -- > > Regards, > > Dave Patrick ....Please no email replies - reply in newsgroup. > Microsoft Certified Professional > Microsoft MVP [Windows] > http://www.microsoft.com/protect > > "Maexi" wrote: > > > > Hi, > > > > I developed a Web Application with Visual Web Developer and SQL Server > > Express Edition on my local PC. Now I rented a Virtual Windows Server 2003 > > (from 1&1) and want transfer the files from my PC to the server. > > It's the first time I am doing this. > > Actually I do not know how to get the database transfered and what to > > consider with the connection string. > > Do I have to install SQL Server Express Edition on the Windows Server 2003 > > ? > > Or do I just have to copy the mdf-file from my local PC to a certain > > folder > > on the server ? > > What do I have to consider with the connection string that I used in my > > applications (webconfig-file) ? > > > > Many thanks in advance ! > > > > Maexi > >
Guest Dave Patrick Posted March 16, 2008 Posted March 16, 2008 Re: SQL Server Express on Virtual Windows Server 2003 It should install according to this page. http://www.microsoft.com/sql/editions/express/sysreqs.mspx They may be able to help you further here. x-posted to; microsoft.public.sqlserver.setup http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.setup&cat=en_US_bf32c3ef-dd94-4bb0-8c60-ff200eedd8c4&lang=en&cr=US -- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "Maexi" wrote: > Thanks Dave. > I created a backup my database and transfered the file (database.bak) to > my > server. But how will I be able to restore it there ? > The Server is a Windows Server 2003, Standard x64 Edition. > It doesn't allow me to install SQL Server Express Edition -> not correct > OP. > Markus > > "Dave Patrick" wrote: > >> No, that wouldn't work. You'll need an instance of SQL Server to host >> your >> MDF/LDF database files. You'll probably want to create a full database >> backup then restore it to the new server. >> >> >> >> -- >> >> Regards, >> >> Dave Patrick ....Please no email replies - reply in newsgroup. >> Microsoft Certified Professional >> Microsoft MVP [Windows] >> http://www.microsoft.com/protect >> >> "Maexi" wrote: >> > >> > Hi, >> > >> > I developed a Web Application with Visual Web Developer and SQL Server >> > Express Edition on my local PC. Now I rented a Virtual Windows Server >> > 2003 >> > (from 1&1) and want transfer the files from my PC to the server. >> > It's the first time I am doing this. >> > Actually I do not know how to get the database transfered and what to >> > consider with the connection string. >> > Do I have to install SQL Server Express Edition on the Windows Server >> > 2003 >> > ? >> > Or do I just have to copy the mdf-file from my local PC to a certain >> > folder >> > on the server ? >> > What do I have to consider with the connection string that I used in my >> > applications (webconfig-file) ? >> > >> > Many thanks in advance ! >> > >> > Maexi >> >>
Guest Dave Patrick Posted March 16, 2008 Posted March 16, 2008 Re: SQL Server Express on Virtual Windows Server 2003 Do you have SP1 installed? -- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "Maexi" wrote: > Thanks Dave. > I created a backup my database and transfered the file (database.bak) to > my > server. But how will I be able to restore it there ? > The Server is a Windows Server 2003, Standard x64 Edition. > It doesn't allow me to install SQL Server Express Edition -> not correct > OP. > Markus
Recommended Posts