Hello,
I need to migrate all my databases to another database
server, can you tell me how can i migrate all the existing
Jobs, DTS's and Alerts sucefully from one server to
another with the minimum effort?
The scheduled DTS's will function on the destination
server?
Thanks,
Best regardsI just went through this. I migrated all my packages using SQL_DMO. I
wrote some code that processed through each DTS package using the DTS
Package Object. The processing I did was to change connection strings, or
any references to server specific stuff, and then saved them onto the new
servers. Did a similar things with the SQL Agent Jobs, and Alerts.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:2478201c45f79$57739290$a501280a@.phx
.gbl...
> Hello,
> I need to migrate all my databases to another database
> server, can you tell me how can i migrate all the existing
> Jobs, DTS's and Alerts sucefully from one server to
> another with the minimum effort?
> The scheduled DTS's will function on the destination
> server?
> Thanks,
> Best regards
>
Showing posts with label databaseserver. Show all posts
Showing posts with label databaseserver. Show all posts
Wednesday, March 21, 2012
Migrate Jobs, DTS and Alerts
Hello,
I need to migrate all my databases to another database
server, can you tell me how can i migrate all the existing
Jobs, DTS's and Alerts sucefully from one server to
another with the minimum effort?
The scheduled DTS's will function on the destination
server?
Thanks,
Best regards
I just went through this. I migrated all my packages using SQL_DMO. I
wrote some code that processed through each DTS package using the DTS
Package Object. The processing I did was to change connection strings, or
any references to server specific stuff, and then saved them onto the new
servers. Did a similar things with the SQL Agent Jobs, and Alerts.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:2478201c45f79$57739290$a501280a@.phx.gbl...
> Hello,
> I need to migrate all my databases to another database
> server, can you tell me how can i migrate all the existing
> Jobs, DTS's and Alerts sucefully from one server to
> another with the minimum effort?
> The scheduled DTS's will function on the destination
> server?
> Thanks,
> Best regards
>
I need to migrate all my databases to another database
server, can you tell me how can i migrate all the existing
Jobs, DTS's and Alerts sucefully from one server to
another with the minimum effort?
The scheduled DTS's will function on the destination
server?
Thanks,
Best regards
I just went through this. I migrated all my packages using SQL_DMO. I
wrote some code that processed through each DTS package using the DTS
Package Object. The processing I did was to change connection strings, or
any references to server specific stuff, and then saved them onto the new
servers. Did a similar things with the SQL Agent Jobs, and Alerts.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:2478201c45f79$57739290$a501280a@.phx.gbl...
> Hello,
> I need to migrate all my databases to another database
> server, can you tell me how can i migrate all the existing
> Jobs, DTS's and Alerts sucefully from one server to
> another with the minimum effort?
> The scheduled DTS's will function on the destination
> server?
> Thanks,
> Best regards
>
Monday, March 19, 2012
Migrate Database with change SQL-Authentifiction to Active Directo
i have a lot of Databaseserver and databases that run with integrated sql
authentification. now i must change the permissions from sql to active
directory interagted authentification. must i create all user and groups new
or can change the type of connect between sql account and active directory
user?You have to create them new, there is no automatic migration path for
that. For this purpose this is a good time to rethink your security
model and how the nt groups can match to the SQL Groups and the
permissions ont he tables.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||i cannot re-design the database structur. i must join the standa-a-lone sql
2000 server based on windows 2000 in a new active directory domain. i have
100 databases. now i locking for a way to change all permission that based on
sql-authentification to active directory objects (that i have created in AD).
can I carry out changing the rights by means of "T SQL"?
"Jens" wrote:
> You have to create them new, there is no automatic migration path for
> that. For this purpose this is a good time to rethink your security
> model and how the nt groups can match to the SQL Groups and the
> permissions ont he tables.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>|||"cannot re-design the database structur."
--Nobody wanted to make you do that. i just mentioned that you could
rethink your security design for that.
"all permission that based on
sql-authentification to active directory objects (that i have created
in AD). "
--Thats a very complicated work which can=B4t be described in some
sentences for your special situation. If the names are the same you
could do that with T-SQL, but that vey specific.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
authentification. now i must change the permissions from sql to active
directory interagted authentification. must i create all user and groups new
or can change the type of connect between sql account and active directory
user?You have to create them new, there is no automatic migration path for
that. For this purpose this is a good time to rethink your security
model and how the nt groups can match to the SQL Groups and the
permissions ont he tables.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||i cannot re-design the database structur. i must join the standa-a-lone sql
2000 server based on windows 2000 in a new active directory domain. i have
100 databases. now i locking for a way to change all permission that based on
sql-authentification to active directory objects (that i have created in AD).
can I carry out changing the rights by means of "T SQL"?
"Jens" wrote:
> You have to create them new, there is no automatic migration path for
> that. For this purpose this is a good time to rethink your security
> model and how the nt groups can match to the SQL Groups and the
> permissions ont he tables.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>|||"cannot re-design the database structur."
--Nobody wanted to make you do that. i just mentioned that you could
rethink your security design for that.
"all permission that based on
sql-authentification to active directory objects (that i have created
in AD). "
--Thats a very complicated work which can=B4t be described in some
sentences for your special situation. If the names are the same you
could do that with T-SQL, but that vey specific.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
Migrate Database with change SQL-Authentifiction to Active Directo
i have a lot of Databaseserver and databases that run with integrated sql
authentification. now i must change the permissions from sql to active
directory interagted authentification. must i create all user and groups new
or can change the type of connect between sql account and active directory
user?You have to create them new, there is no automatic migration path for
that. For this purpose this is a good time to rethink your security
model and how the nt groups can match to the SQL Groups and the
permissions ont he tables.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
authentification. now i must change the permissions from sql to active
directory interagted authentification. must i create all user and groups new
or can change the type of connect between sql account and active directory
user?You have to create them new, there is no automatic migration path for
that. For this purpose this is a good time to rethink your security
model and how the nt groups can match to the SQL Groups and the
permissions ont he tables.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
Migrate Database with change SQL-Authentifiction to Active Directo
i have a lot of Databaseserver and databases that run with integrated sql
authentification. now i must change the permissions from sql to active
directory interagted authentification. must i create all user and groups new
or can change the type of connect between sql account and active directory
user?
You have to create them new, there is no automatic migration path for
that. For this purpose this is a good time to rethink your security
model and how the nt groups can match to the SQL Groups and the
permissions ont he tables.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
authentification. now i must change the permissions from sql to active
directory interagted authentification. must i create all user and groups new
or can change the type of connect between sql account and active directory
user?
You have to create them new, there is no automatic migration path for
that. For this purpose this is a good time to rethink your security
model and how the nt groups can match to the SQL Groups and the
permissions ont he tables.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
Subscribe to:
Posts (Atom)