MS SQL Server - SQL Server Express

Author

SQL Server Express

Brett_A

2006-12-11, 7:13 pm

Just so I'm understanding what I've been reading here and
elsewhere...I'm making the jump from Access to SQL Server for web
back-ends.

There is no way to use SQL Server Management Studio Express to
"upsize"/export/transfer a db sitting in SQL Server Express to SQL
Server.

I've developed a db in SQL Server Express and now I need to transfer it
to my shared SQL server space at my host and I can't find a simple way
(microsoft way) to move the db without upgrading to the SQL Server
Management Studio.

Is this correct?

I found the product Teratrax Database Manager which says it can move
db's between SQL Server Express and SQL Server. Is this a good product
and does it actually do this?

All suggestions/advice is welcome.

Thanks.

Brett

Razvan Socol

2006-12-11, 7:13 pm

The preferred methods to transfer a database between two SQL Servers
(Express or other editions) are:
a) backup / restore
b) dettach / attach

If you cannot copy files to your host, you might want to use scripting,
which is the method used by Database Publishing Wizard:
http://www.codeplex.com/Wiki/View.a...ishing%20Wizard

Razvan

Norman Yuan

2006-12-11, 7:13 pm

Wrong. You can SQL Server Management Studio Express to "move" a database
between SQL Server/Express, or you can simply use osql tool or any tool that
allows you to run a SQL script, to attach/detach, backup/restore database,
as long as you have proper accessibility to the SQL Server/Express.

If your SQL Server database is hosted somewhere, you need to ask the service
provider to give you needed permission to access the hosting SQL Server, or
they do it for you, or they provide some way/tool to allow you to do that.
It has nothing to do with you using SQL Server Express.

"Brett_A" <brettatkin@gmail.com> wrote in message
news:1165864329.885520.197390@f1g2000cwa.googlegroups.com...
> Just so I'm understanding what I've been reading here and
> elsewhere...I'm making the jump from Access to SQL Server for web
> back-ends.
>
> There is no way to use SQL Server Management Studio Express to
> "upsize"/export/transfer a db sitting in SQL Server Express to SQL
> Server.
>
> I've developed a db in SQL Server Express and now I need to transfer it
> to my shared SQL server space at my host and I can't find a simple way
> (microsoft way) to move the db without upgrading to the SQL Server
> Management Studio.
>
> Is this correct?
>
> I found the product Teratrax Database Manager which says it can move
> db's between SQL Server Express and SQL Server. Is this a good product
> and does it actually do this?
>
> All suggestions/advice is welcome.
>
> Thanks.
>
> Brett
>

Sponsored Links