Help on sql sync

Hi, all
We have prod. database and test db(new version of prod, table fields
changed).
Production db has users connected and updating records and I need to have
user transactions in production db updated in test db as well.
I can't use log shipping to sync them because of the table structures a
little diff or some datatype changed in new version(test db).
I can't do the DTS neither. It may have too many tables effected.
What is the best way to do the sync.
thanks in advanceThere is table replication in sql 2k?
Thanks
"mecn" <mecn2002@.yahoo.com> wrote in message
news:uiulJTD2GHA.476@.TK2MSFTNGP06.phx.gbl...
> Hi, all
> We have prod. database and test db(new version of prod, table fields
> changed).
> Production db has users connected and updating records and I need to have
> user transactions in production db updated in test db as well.
> I can't use log shipping to sync them because of the table structures a
> little diff or some datatype changed in new version(test db).
> I can't do the DTS neither. It may have too many tables effected.
> What is the best way to do the sync.
> thanks in advance
>
>
>
>
>|||Hi,
You can not use Logshiiping or Replication because based on my understanding
both environments are in read/write mode. Due to this we can not apply the
transaction log file. The best way for you is to write a batch file to do
frequent updates.
Thanks
Hari
SQL Server MVP
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23GpcOWD2GHA.1568@.TK2MSFTNGP03.phx.gbl...
> There is table replication in sql 2k?
> Thanks
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:uiulJTD2GHA.476@.TK2MSFTNGP06.phx.gbl...
>|||You can use transactional replication to replicate to tables of different
schemas. See this for more info.
http://www.dbazine.com/sql/sql-articles/cotter1
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"mecn" <mecn2002@.yahoo.com> wrote in message
news:uiulJTD2GHA.476@.TK2MSFTNGP06.phx.gbl...
> Hi, all
> We have prod. database and test db(new version of prod, table fields
> changed).
> Production db has users connected and updating records and I need to have
> user transactions in production db updated in test db as well.
> I can't use log shipping to sync them because of the table structures a
> little diff or some datatype changed in new version(test db).
> I can't do the DTS neither. It may have too many tables effected.
> What is the best way to do the sync.
> thanks in advance
>
>
>
>
>

Help on sql sync

Hi, all
We have prod. database and test db(new version of prod, table fields
changed).
Production db has users connected and updating records and I need to have
user transactions in production db updated in test db as well.
I can't use log shipping to sync them because of the table structures a
little diff or some datatype changed in new version(test db).
I can't do the DTS neither. It may have too many tables effected.
What is the best way to do the sync.
thanks in advance
There is table replication in sql 2k?
Thanks
"mecn" <mecn2002@.yahoo.com> wrote in message
news:uiulJTD2GHA.476@.TK2MSFTNGP06.phx.gbl...
> Hi, all
> We have prod. database and test db(new version of prod, table fields
> changed).
> Production db has users connected and updating records and I need to have
> user transactions in production db updated in test db as well.
> I can't use log shipping to sync them because of the table structures a
> little diff or some datatype changed in new version(test db).
> I can't do the DTS neither. It may have too many tables effected.
> What is the best way to do the sync.
> thanks in advance
>
>
>
>
>
|||Hi,
You can not use Logshiiping or Replication because based on my understanding
both environments are in read/write mode. Due to this we can not apply the
transaction log file. The best way for you is to write a batch file to do
frequent updates.
Thanks
Hari
SQL Server MVP
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23GpcOWD2GHA.1568@.TK2MSFTNGP03.phx.gbl...
> There is table replication in sql 2k?
> Thanks
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:uiulJTD2GHA.476@.TK2MSFTNGP06.phx.gbl...
>
|||You can use transactional replication to replicate to tables of different
schemas. See this for more info.
http://www.dbazine.com/sql/sql-articles/cotter1
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"mecn" <mecn2002@.yahoo.com> wrote in message
news:uiulJTD2GHA.476@.TK2MSFTNGP06.phx.gbl...
> Hi, all
> We have prod. database and test db(new version of prod, table fields
> changed).
> Production db has users connected and updating records and I need to have
> user transactions in production db updated in test db as well.
> I can't use log shipping to sync them because of the table structures a
> little diff or some datatype changed in new version(test db).
> I can't do the DTS neither. It may have too many tables effected.
> What is the best way to do the sync.
> thanks in advance
>
>
>
>
>

Help on Registering SQL Server in Enterprise Admin

Dear All
We want to monitor SQL job history for 50+ servers using id which doesn't
have admin priviliges on server and database. On database front I can
achieveit by assiging TargetServer role but I want to add all servers in
Enterprise Administartor console. What are minimum rights we require to
register server in Enterprise Admin for Windows 2000 & 2003 Servers?
Rahul> Enterprise Administartor console. What are minimum rights we require to
> register server in Enterprise Admin for Windows 2000 & 2003 Servers?
You will have EM installed on your workstation and to know a login and
password to register the SQL Server
"rahulpt" <rahulpt@.discussions.microsoft.com> wrote in message
news:36C3F6A6-BBF7-41A1-A97B-E5EC3A6AD6F9@.microsoft.com...
> Dear All
> We want to monitor SQL job history for 50+ servers using id which doesn't
> have admin priviliges on server and database. On database front I can
> achieveit by assiging TargetServer role but I want to add all servers in
> Enterprise Administartor console. What are minimum rights we require to
> register server in Enterprise Admin for Windows 2000 & 2003 Servers?
> --
> Rahul|||The minimum 'rights' to register a server are to be able to log into the ser
ver. It is not necessary to have permissions for any database.
However, in order to view the job history in EM (SQL 2000), I think that it
will be necessary to be in the sysadmin server role for all servers. (I'm a
little fuzzy on this...)
For Management Studio (SQL 2005) you must be in the SQLAgentReaderRole (or s
ysadmin) in order to view Job history of all the jobs.
If you used Query Analyzer and had some form or script, it would be necessar
y to only have SELECT permissions on the various sysjob... tables in the msd
b databases.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"rahulpt" <rahulpt@.discussions.microsoft.com> wrote in message news:36C3F6A6-BBF7-41A1-A97B-
E5EC3A6AD6F9@.microsoft.com...
> Dear All
>
> We want to monitor SQL job history for 50+ servers using id which doesn't
> have admin priviliges on server and database. On database front I can
> achieveit by assiging TargetServer role but I want to add all servers in
> Enterprise Administartor console. What are minimum rights we require to
> register server in Enterprise Admin for Windows 2000 & 2003 Servers?
>
> --
> Rahul|||Dear All
Thanks for your inputrs. But how I will give permission to domain user to
log on to SQL Server? Do you mean by adding user in SQL Login? Also when we
add user to SQL it asks for "Database" name, like master etc or user created
like test,test1 etc.
So which database we need to assign while adding user to sql login and what
will be security implications of same? I.e.if we add user with database as
master or user database test then what rights the user will have on these
databases'
Rahul
"Arnie Rowland" wrote:
[vbcol=seagreen]
> The minimum 'rights' to register a server are to be able to log into the s
erver. It is not necessary to have permissions for any database.
> However, in order to view the job history in EM (SQL 2000), I think that i
t will be necessary to be in the sysadmin server role for all servers. (I'm
a little fuzzy on this...)
> For Management Studio (SQL 2005) you must be in the SQLAgentReaderRole (or
sysadmin) in order to view Job history of all the jobs.
> If you used Query Analyzer and had some form or script, it would be necess
ary to only have SELECT permissions on the various sysjob... tables in the m
sdb databases.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "rahulpt" <rahulpt@.discussions.microsoft.com> wrote in message news:36C3F6
A6-BBF7-41A1-A97B-E5EC3A6AD6F9@.microsoft.com...