SQL Server Express on Virtual Windows Server 2003

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

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

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

>

>

[Guest 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/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]

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