SQL Server Express on Virtual Windows Server 2003

[Maexi]

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

 

[Dave Patrick]

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

 

[Maexi]

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
>
>

 

[Dave Patrick]

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/communitie...3ef-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
>>
>>

 

[Dave Patrick]

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