SQL Express =非常好但是...... [英] SQL Express = really nice but...

问题描述

我去年玩了ASP.net 2.0，但得到了sidtracked并且没有机会直到最近再次潜入它。我现在正计划完全支持
转到2.0和VS.2005


几乎每个2.0教程都使用SQL Express。我很喜欢。这是很好的，与VS很好地融合在一起很好的把它包含在我的应用程序中。

。此外，它使得离线工作变得非常容易，而无需为完整的SQL许可证支付

。


然而，一个问题是它没有在实际生产中使用

似乎是一个实用的数据库，因为没有网络主机想要支持它。


所以，我只是错过了一个基本概念？ SQL Express只能用于

RAD，然后将所有内容切换为完整的SQL吗？如果是这样，是否有一种简单的方法可以将你的SQLExpress应用程序迁移到完整的SQL？


-Darrel

I played with ASP.net 2.0 last year a bit but got sidtracked and haven''t had
a chance to dive into it again until recently. I''m now planning on fully
going over to 2.0 and VS.2005

Pretty much every tutorial for 2.0 used SQL Express. I really like it. It''s
slick, integrated well with VS and it''s nice to have it ''contained'' within
my app. Plus, it makes it really easy to work offline without having to pay
for a full SQL license.

The one catch, though, is that it doesn''t seem to be a practical DB to use
in actual production as none of the web hosts want to support it.

So, am I just missing a basic concept? Should SQL Express ONLY be used for
RAD and then switch everything to full SQL? IF so, is there an easy way to
migrate your SQLExpress app over to full SQL?

-Darrel

推荐答案

您是否使用过WebHost4life.com进行了检查？他们支持SQL Express。

你对你的网站有什么样的流量？

这是你真正需要问自己的问题：

是否需要SQL 2005中没有包含在SQL中的功能

Express？"


（如果你使用WH4Life） ，请使用''dwier''作为推荐ID）

-

David Wier

MVP / ASPInsider
http://aspnet101.com
http://aspexpress.com

" darrel" < no ***** @ nowhere.com写了留言

新闻：O2 ************* @ TK2MSFTNGP02.phx.gbl ...

Have you checked with WebHost4life.com? They support SQL Express.
What kind of traffic are you expecting with your site?
Here''s the question you really need to ask yourself:
"Is there any need for features in SQL 2005 that are not included in SQL
Express?"

(if you go with WH4Life, please use ''dwier'' for a referral id)
--
David Wier
MVP/ASPInsider
http://aspnet101.com
http://aspexpress.com
"darrel" <no*****@nowhere.comwrote in message
news:O2*************@TK2MSFTNGP02.phx.gbl...

我去年玩过ASP.net 2.0但有点sidtracked并且没有

I played with ASP.net 2.0 last year a bit but got sidtracked and haven''t

有

had

a直到最近再次潜入它的机会。我现在正计划完全支持
转到2.0和VS.2005


几乎每个2.0教程都使用SQL Express。我很喜欢。

a chance to dive into it again until recently. I''m now planning on fully
going over to 2.0 and VS.2005

Pretty much every tutorial for 2.0 used SQL Express. I really like it.

它是

It''s

slick，与VS很好地集成，很高兴有它''包含''

我的应用程序。此外，它使得离线工作变得非常容易，而无需

slick, integrated well with VS and it''s nice to have it ''contained'' within
my app. Plus, it makes it really easy to work offline without having to

支付

pay

完整SQL的
许可证。


然而，一个问题是，在实际生产中使用

似乎不是一个实用的数据库。网站主机想要支持它。


所以，我只是错过了一个基本概念？ SQL Express只能用于

RAD，然后将所有内容切换为完整的SQL吗？如果是这样，是否有一种简单的方法可以将你的SQLExpress应用程序迁移到完整的SQL？


-Darrel

for a full SQL license.

The one catch, though, is that it doesn''t seem to be a practical DB to use
in actual production as none of the web hosts want to support it.

So, am I just missing a basic concept? Should SQL Express ONLY be used for
RAD and then switch everything to full SQL? IF so, is there an easy way to
migrate your SQLExpress app over to full SQL?

-Darrel

re：

然而，一个问题是它看起来似乎没有是一个在实际生产中使用的实用数据库，因为没有网络主机想要支持它。

The one catch, though, is that it doesn''t seem to be a practical DB to use in actual production as
none of the web hosts want to support it.

它不是为生产用途而设计的。


re：

It''s not designed for production use.

re:

所以，我只是错过了一个基本概念？ SQL Express只能用于RAD，然后将所有内容切换为完整的SQL吗？

So, am I just missing a basic concept? Should SQL Express ONLY be used for RAD and then switch
everything to full SQL?

这就是这个想法。


re：

That''s pretty much the idea.

re:

如果是这样，是否有一种简单的方法可以将SQLExpress应用程序迁移到完整的SQL？

IF so, is there an easy way to migrate your SQLExpress app over to full SQL?

使用SQL Server Management Studio的导入和导出向导

将数据复制到远程SQL Server数据库。


下载管理工作室：
http://www.microsoft.com/downloads/d...DisplayLang=en


确保以您想要的语言下载正确的32或64位版本。


这是程序的简要说明：
http://aspalliance.com/888_Exporting...ote_SQL_Server


Juan T. Llibre，asp.net MVP

asp.net faq： http://asp.net.do/faq/

foros de asp.net，en espa？ol ： http://asp.net.do/foros/

===================================

" darrel" ; < no ***** @ nowhere.com在消息新闻中写道：O2 ************* @ TK2MSFTNGP02.phx.gbl ...

Use the Import and Export Wizard of SQL Server Management Studio
to copy the data to your remote SQL Server database.

Download the Management Studio at:
http://www.microsoft.com/downloads/d...DisplayLang=en

Make sure you download the right version, 32 or 64 bit, in the language you want.

Here''s a rundown on the procedure:
http://aspalliance.com/888_Exporting...ote_SQL_Server


Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en espa?ol : http://asp.net.do/foros/
===================================
"darrel" <no*****@nowhere.comwrote in message news:O2*************@TK2MSFTNGP02.phx.gbl...

>我去年玩了ASP.net 2.0，但是得到了sidtracked并且没有机会再次潜入
它直到最近。我现在正计划完全转向2.0和VS.2005


几乎每个2.0教程都使用SQL Express。我很喜欢。它很光滑，与VS很好地集成在一起，并且很高兴在我的应用程序中包含它''。此外，它使得工作非常简单，无需支付完整的SQL许可证即可离线工作。


然而，一个问题是它没有在实际生产中使用它似乎是一个实用的数据库。

没有网络主机想要支持它。


所以，我只是错过了一个基本概念？ SQL Express只能用于RAD，然后将所有内容切换为完整的SQL吗？如果是这样，是否有一种简单的方法可以将您的SQLExpress应用程序迁移到完整的

SQL？


-Darrel

>I played with ASP.net 2.0 last year a bit but got sidtracked and haven''t had a chance to dive into
it again until recently. I''m now planning on fully going over to 2.0 and VS.2005

Pretty much every tutorial for 2.0 used SQL Express. I really like it. It''s slick, integrated well
with VS and it''s nice to have it ''contained'' within my app. Plus, it makes it really easy to work
offline without having to pay for a full SQL license.

The one catch, though, is that it doesn''t seem to be a practical DB to use in actual production as
none of the web hosts want to support it.

So, am I just missing a basic concept? Should SQL Express ONLY be used for RAD and then switch
everything to full SQL? IF so, is there an easy way to migrate your SQLExpress app over to full
SQL?

-Darrel

它不是为生产用途而设计的。


....这看起来像是免费的产品，我想...; o）

It''s not designed for production use.

....which makes sense seeing as how it''s a Free product, I suppose... ;o)

re：

re:

> IF如此，是有一种简单的方法可以将您的SQLExpress应用程序迁移到完整的SQL吗？

>IF so, is there an easy way to migrate your SQLExpress app over to full
SQL?

使用SQL Server Management Studio的导入和导出向导

将数据复制到远程SQL Server数据库。

Use the Import and Export Wizard of SQL Server Management Studio
to copy the data to your remote SQL Server database.

很酷！将检查出来。


-Darrel

Cool! Will check that out.

-Darrel

这篇关于SQL Express =非常好但是......的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！