deploying SQL server applications to another machine

Hi -
Let me start off by saying that I am a complete SQL server newbie.
I work with a system that uses SQL Server 2005 as it's backbone DB
running on W2K3 server. This system is going to be installed onto
customer servers, also running W2K3 server. Question is; is there a
way to deploy all aspects of JUST THE DB (tables, stored procedures,
security, users, etc...) to the customers servers without having to do
a full up install of SQL Server 2005 on every server that will host a
database?
ThanksYou need some process to read and interact with the database files. The only such process I know of
is ... SQL Server. Now, that can be Express edition, but it need to be some version of SQL Server...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<ecfiedler@.impactsci.com> wrote in message
news:1179865512.394536.163730@.q69g2000hsb.googlegroups.com...
> Hi -
> Let me start off by saying that I am a complete SQL server newbie.
> I work with a system that uses SQL Server 2005 as it's backbone DB
> running on W2K3 server. This system is going to be installed onto
> customer servers, also running W2K3 server. Question is; is there a
> way to deploy all aspects of JUST THE DB (tables, stored procedures,
> security, users, etc...) to the customers servers without having to do
> a full up install of SQL Server 2005 on every server that will host a
> database?
> Thanks
>

deploying SQL server applications to another machine

Hi -
Let me start off by saying that I am a complete SQL server newbie.
I work with a system that uses SQL Server 2005 as it's backbone DB
running on W2K3 server. This system is going to be installed onto
customer servers, also running W2K3 server. Question is; is there a
way to deploy all aspects of JUST THE DB (tables, stored procedures,
security, users, etc...) to the customers servers without having to do
a full up install of SQL Server 2005 on every server that will host a
database?
Thanks
You need some process to read and interact with the database files. The only such process I know of
is ... SQL Server. Now, that can be Express edition, but it need to be some version of SQL Server...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<ecfiedler@.impactsci.com> wrote in message
news:1179865512.394536.163730@.q69g2000hsb.googlegr oups.com...
> Hi -
> Let me start off by saying that I am a complete SQL server newbie.
> I work with a system that uses SQL Server 2005 as it's backbone DB
> running on W2K3 server. This system is going to be installed onto
> customer servers, also running W2K3 server. Question is; is there a
> way to deploy all aspects of JUST THE DB (tables, stored procedures,
> security, users, etc...) to the customers servers without having to do
> a full up install of SQL Server 2005 on every server that will host a
> database?
> Thanks
>

deploying SQL server applications to another machine

Hi -
Let me start off by saying that I am a complete SQL server newbie.
I work with a system that uses SQL Server 2005 as it's backbone DB
running on W2K3 server. This system is going to be installed onto
customer servers, also running W2K3 server. Question is; is there a
way to deploy all aspects of JUST THE DB (tables, stored procedures,
security, users, etc...) to the customers servers without having to do
a full up install of SQL Server 2005 on every server that will host a
database?
ThanksYou need some process to read and interact with the database files. The only
such process I know of
is ... SQL Server. Now, that can be Express edition, but it need to be some
version of SQL Server...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<ecfiedler@.impactsci.com> wrote in message
news:1179865512.394536.163730@.q69g2000hsb.googlegroups.com...
> Hi -
> Let me start off by saying that I am a complete SQL server newbie.
> I work with a system that uses SQL Server 2005 as it's backbone DB
> running on W2K3 server. This system is going to be installed onto
> customer servers, also running W2K3 server. Question is; is there a
> way to deploy all aspects of JUST THE DB (tables, stored procedures,
> security, users, etc...) to the customers servers without having to do
> a full up install of SQL Server 2005 on every server that will host a
> database?
> Thanks
>

Deploying CLR Stored Procedures to a client, is there a better way

I'm developing an application locally, and after I complete major revisitions/bugfixes, I transfer the code/database changes to the client. If I change the code for a CLR stored procedure locally, I can just deploy the project to the local database, which handles everything for me.

Transferring to the client's database is more difficult, however. In order to update the CLR procedures, I need to drop my regular stored procedures, drop my functions, drop the CLR procs, and then re-add the CLR procs, functions and stored procedures to avoid errors based on dependencies. The stored procs/functions don't change, and it seems like there should be a way to just insert the new CLR stuff without dealing with the regular stored procedures or userdefined functions.

Basically, I'm asking whether there is a better way to do this, or if I'm stuck doing this excessive routine every time I need to update.

Thanks in advance

it sounds like your in the "debug" phase right now, so you could use multiple assemblies to seperate those SQLCLR routines that you know are still giving you problems and those that are not. Once fully tested you could then re-merge them back into one assembly.

You could also look at using the scripting wizard to script the assembly and all of it's dependencies from your local/dev box.

Derek

|||

Have you tried using ALTER ASSEMBLY from T-SQL to deploy changes to the assembly.

Detailed documentation on ALTER ASSEMBLY is available at http://msdn2.microsoft.com/en-us/library/ms186711(d=ide).aspx

Thanks,

-Vineet

Deploying Analysis Services 2000 without data

Hi there :-)

I want to deploy a complete Analysis Services database from our development server to the live server, but without archiving it and having to send a couple of gig in data!

I can't see anywhere in the Analysis Manager to just script the whole thing as i would with a SQL Server database?

The live server is on a different network maintained by a thrid party and it will be a real pain if we have to send the whole thing on disk every time we want to make a change. I am working from a local copy of the source SQL Server database.

I'm a bit of a newby so please forgive me if it's completely obvious and i have just missed it. All i want to do is get an empty copy of the whole thing with all it's (empty) cubes, change the connection to the true live source SQL Server database and then build the data there.

Please help!

Regards,

Richard

For AS2000, in Analysis Manager:

- copy-paste the database (that will only copy the object definitions, but not the data)

- archive the copy (there is a right click menu on the database item, a .cab file will be generated)

- restore on the other server (right click menu on the server item)

Adrian Dumitrascu

|||

Thanks Adrian

Wow! I had assumed the data was copied when you copy the database. This is perfect!

Thanks for the information!!

Richard

Deploy Cubes

Hi

I want to deploy a complete analysis db (with the cubes and dimension) to another server. As I have learned it is possible to use backup and restore. But with this method also the data is transferred which is quite a headache when the cubes are already processed and contain a lot of data. Is it possible to just export the definition. Btw: It's analysis services 2000.

Thanks in advance

Thomas

Nobody?

Your answer would be greatly appreciated.

Thomas

|||

I think copy-paste in Analysis Manager would do the trick.

B.

|||

Hi Brian

Thanks for your reply. I will try it.

But one question to that. Copy paste method is not very friendly in a bigger scenario, where one developer creates the cubes and some companies on other location will use it. Also backup is not possible this way.

What are the methods to achieve this?

Regards

Thomas

|||

The options with AS 2000 are pretty weak. You can either backup & restore or copy-paste & reprocess. One variation is to backup an empty database, restore it, then reprocess.

In 2005, you can migrate changes through scripts. Some change will require reprocessing, but many do not.

B.

|||

Ok, thanks a lot.

Regards

Thomas

Deny remote access to MSDE for some users

HI!
I'm a complete MSDE newbie but I have to clarify an open question about
access control with MSDE 2000 running on WinNT 4.0:
Is it possible to grant some admin users remote access to the MSDE but
restrict other local users to local access?
Ciao, Michael.
hi Michael,
Michael Strder wrote:
> HI!
> I'm a complete MSDE newbie but I have to clarify an open question
> about access control with MSDE 2000 running on WinNT 4.0:
> Is it possible to grant some admin users remote access to the MSDE but
> restrict other local users to local access?
yes, of course..
you have to grant the remote logins access to the MSDE instance via the
sp_grantlogin system stored procedure
(http://msdn.microsoft.com/library/de...-us/tsqlref/ts
_sp_ga-gz_8dri.asp), while you have to deny local logins via sp_denylogin...
please have a look at
http://support.microsoft.com/default...;EN-US;q325003 for futher
info about how to perform these tasks via oSql.exe, the command line tool
provided with MSDE
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrea,
first many thanks for the pointers.
Andrea Montanari wrote:
> hi Michael,
> Michael Strder wrote:
> you have to grant the remote logins access to the MSDE instance via the
> sp_grantlogin system stored procedure
> (http://msdn.microsoft.com/library/de...-us/tsqlref/ts
> _sp_ga-gz_8dri.asp), while you have to deny local logins via sp_denylogin...
Let's assume I use Windows authentication for MSDE. Is the whole access
control also done via Windows rights based on groups? How to disallow a
remote login for local users then?
Ciao, Michael.
|||ciao Michael,
> ..
> Let's assume I use Windows authentication for MSDE. Is the whole
> access control also done via Windows rights based on groups? How to
> disallow a remote login for local users then?
let's say you have YourDomain\theUser member of TheGroup\
you want TheGroup\ to be able to connect to MSDE, so you grant
(sp_grantlogin) it connection...
but you want YourDomain\theUser not to be able to connect to MSDE .. you
deny YourDomain\theUser connection to MSDE via sp_denylogin...
this way you have YourDomain\TheGroup able to connect and YourDomain\theUser
unable...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply