Couldn't Replicate ???

Jan 4, 2006

Hi,

I'm new to replication.
I configured Server named TESTER as publisher & distributer. Create new publication for database named TEST ( type : Transactional ), then Create a new push subcriptions for database TESTREPLICATION ( on the same Server : TESTER). Then I open a table in database TEST to input some data but I couldn't see any tables or data in database TESTREPLICATION ( I chose Continuously, not scheduled).

Yet, after the lunch, I could see the tables, no data. I tried to choose Start Synchronizing but not helped.

Please tell me if I configured incorrectly ?

Thanks,

View 7 Replies

Replicate Schema/Replicate Data Only

Sep 7, 1999

Using SQL 7.0 I'd like to replicate just schema from DB on server A to DB on server B, then be able to replicate data only form DB on server B to DB on server A. I need help!!

Thanks for ANY information you can give me...
~Jepadria

View 2 Replies View Related

Couldn't Find SSMS

Feb 2, 2006

Hi,

I have just installed sql server 2005 enterprise edition. I am totally new to sqlserver. I want to create a database in sql server and access that from my VB.net application. I couldn't find sql server management studio to create a database. can somebody help me with this...

thanks,
Leela

View 3 Replies View Related

I Couldn't Find Appropriate SQL Queries

Feb 6, 2007

Because forum HTML codes are OFF I had to put my question between code tags. Because to tell my question I had to show the database tables and wanted output. I succeeded retrieving the datas but combining these three tables together with SQL or ASP codes is too complex. Please help me determining the table. As I am subscribed to this forum you can ask me anything about my question. I can clarify my question if you need. Your answers will be replied immediately.
(To see my question pls save the codes below as htm file or see it with a wysiwyg editor.)

tbl_PRODUCTIONS
<table border="1" width="971" id="table1">
<tr>
<td height="19" width="54">fld_DATE</td>
<td width="161" height="19">fld_PRODUCER_UNITCODE</td>
<td height="19" width="124">fld_PRODUCT_CODE</td>
<td height="19" width="222">fld_DAILY_PRODUCTION_PROGRAM</td>
<td height="19" width="176">fld_PRODUCTION_QUANTITY</td>
<td height="19" width="136">fld_STOCK_QUANTITY</td>
<td height="19" width="52">fld_SELL</td>
</tr>
<tr>
<td width="54" >......</td>
<td width="161" >....</td>
<td width="124">....</td>
<td width="222">....</td>
<td width="176">....</td>
<td width="136">.....</td>
<td width="52">....</td>
</tr>
<tr>
<td width="54" >18.01.2007</td>
<td width="161" >IST</td>
<td width="124">1.10</td>
<td width="222">100</td>
<td width="176">115</td>
<td width="136">100</td>
<td width="52">10</td>
</tr>
<tr>
<td width="54" >18.01.2007</td>
<td width="161" >IST</td>
<td width="124">1.20</td>
<td width="222">200</td>
<td width="176">190</td>
<td width="136">200</td>
<td width="52">54</td>
</tr>
<tr>
<td width="54" >18.01.2007</td>
<td width="161" >ANK</td>
<td width="124">2.110.12</td>
<td width="222">300</td>
<td width="176">350</td>
<td width="136">450</td>
<td width="52">745</td>
</tr>
<tr>
<td width="54" >18.01.2007</td>
<td width="161" >ANK</td>
<td width="124">12.128.43</td>
<td width="222">150</td>
<td width="176">150</td>
<td width="136">4664</td>
<td width="52">55</td>
</tr>
<tr>
<td width="54" >18.01.2007</td>
<td width="161" >IZM</td>
<td width="124">6.142.42</td>
<td width="222">100</td>
<td width="176">100</td>
<td width="136">234</td>
<td width="52">77</td>
</tr>
<tr>
<td width="54" >18.01.2007</td>
<td width="161" >IZM</td>
<td width="124">9.86.50</td>
<td width="222">125</td>
<td width="176">135</td>
<td width="136">654</td>
<td width="52">80</td>
</tr>
<tr>
<td width="54" >18.01.2007</td>
<td width="161" >IZM</td>
<td width="124">12.43.250</td>
<td width="222">75</td>
<td width="176">80</td>
<td width="136">233</td>
<td width="52">101</td>
</tr>
<tr>
<td width="54" >19.01.2007</td>
<td width="161" >IST</td>
<td width="124">1.10</td>
<td width="222">100</td>
<td width="176">99</td>
<td width="136">100</td>
<td width="52">10</td>
</tr>
<tr>
<td width="54" >19.01.2007</td>
<td width="161" >IST</td>
<td width="124">1.20</td>
<td width="222">200</td>
<td width="176">210</td>
<td width="136">200</td>
<td width="52">54</td>
</tr>
<tr>
<td width="54" >19.01.2007</td>
<td width="161" >ANK</td>
<td width="124">2.110.12</td>
<td width="222">300</td>
<td width="176">309</td>
<td width="136">450</td>
<td width="52">745</td>
</tr>
<tr>
<td width="54" >19.01.2007</td>
<td width="161" >ANK</td>
<td width="124">12.128.43</td>
<td width="222">150</td>
<td width="176">155</td>
<td width="136">4664</td>
<td width="52">55</td>
</tr>
<tr>
<td width="54" >19.01.2007</td>
<td width="161" >IZM</td>
<td width="124">6.142.42</td>
<td width="222">100</td>
<td width="176">100</td>
<td width="136">234</td>
<td width="52">77</td>
</tr>
<tr>
<td width="54" >19.01.2007</td>
<td width="161" >IZM</td>
<td width="124">9.86.50</td>
<td width="222">125</td>
<td width="176">90</td>
<td width="136">654</td>
<td width="52">80</td>
</tr>
<tr>
<td width="54" >19.01.2007</td>
<td width="161" >IZM</td>
<td width="124">12.43.250</td>
<td width="222">75</td>
<td width="176">60</td>
<td width="136">233</td>
<td width="52">101</td>
</tr>
<tr>
<td width="54" >20.01.2007</td>
<td width="161" >IST</td>
<td width="124">1.10</td>
<td width="222">100</td>
<td width="176">90</td>
<td width="136">100</td>
<td width="52">10</td>
</tr>
<tr>
<td width="54" >20.01.2007</td>
<td width="161" >IST</td>
<td width="124">1.20</td>
<td width="222">200</td>
<td width="176">190</td>
<td width="136">200</td>
<td width="52">54</td>
</tr>
<tr>
<td width="54" >20.01.2007</td>
<td width="161" >ANK</td>
<td width="124">2.110.12</td>
<td width="222">300</td>
<td width="176">350</td>
<td width="136">450</td>
<td width="52">745</td>
</tr>
<tr>
<td width="54" >20.01.2007</td>
<td width="161" >ANK</td>
<td width="124">12.128.43</td>
<td width="222">150</td>
<td width="176">156</td>
<td width="136">4664</td>
<td width="52">55</td>
</tr>
<tr>
<td width="54" >20.01.2007</td>
<td width="161" >IZM</td>
<td width="124">6.142.42</td>
<td width="222">100</td>
<td width="176">120</td>
<td width="136">234</td>
<td width="52">77</td>
</tr>
<tr>
<td width="54" >20.01.2007</td>
<td width="161" >IZM</td>
<td width="124">9.86.50</td>
<td width="222">125</td>
<td width="176">140</td>
<td width="136">654</td>
<td width="52">80</td>
</tr>
<tr>
<td width="54" >20.01.2007</td>
<td width="161" >IZM</td>
<td width="124">12.43.250</td>
<td width="222">75</td>
<td width="176">90</td>
<td width="136">233</td>
<td width="52">101</td>
</tr>
<tr>
<td width="54" >...</td>
<td width="161" >....</td>
<td width="124">....</td>
<td width="222">....</td>
<td width="176">....</td>
<td width="136">....</td>
<td width="52">....</td>
</tr>
</table>

� 
tbl_ANNUAL_PRG
<table border="1" width="552" id="table2">
<tr>
<td width="62">fld_YEARS</td>
<td>fld_PRODUCER_UNITCODE</td>
<td>fld_PRODUCT_CODE</td>
<td width="177">fld_PRODUCTION_PROGRAM</td>
</tr>
<tr>
<td width="62">2006</td>
<td width="161" >IST</td>
<td width="124">1.10</td>
<td width="177">15000</td>
</tr>
<tr>
<td width="62">2006</td>
<td width="161" >IST</td>
<td width="124">1.20</td>
<td width="177">22000</td>
</tr>
<tr>
<td width="62">2006</td>
<td width="161" >ANK</td>
<td width="124">2.110.12</td>
<td width="177">35000</td>
</tr>
<tr>
<td width="62">2006</td>
<td width="161" >ANK</td>
<td width="124">12.128.43</td>
<td width="177">50000</td>
</tr>
<tr>
<td width="62">2006</td>
<td width="161" >IZM</td>
<td width="124">6.142.42</td>
<td width="177">170000</td>
</tr>
<tr>
<td width="62">2006</td>
<td width="161" >IZM</td>
<td width="124">9.86.50</td>
<td width="177">12000</td>
</tr>
<tr>
<td width="62">2006</td>
<td width="161" >IZM</td>
<td width="124">12.43.250</td>
<td width="177">123000</td>
</tr>
<tr>
<td width="62">2007</td>
<td width="161" >IST</td>
<td width="124">1.10</td>
<td width="177">18000</td>
</tr>
<tr>
<td width="62">2007</td>
<td width="161" >IST</td>
<td width="124">1.20</td>
<td width="177">25000</td>
</tr>
<tr>
<td width="62">2007</td>
<td width="161" >ANK</td>
<td width="124">2.110.12</td>
<td width="177">32000</td>
</tr>
<tr>
<td width="62">2007</td>
<td width="161" >ANK</td>
<td width="124">12.128.43</td>
<td width="177">55000</td>
</tr>
<tr>
<td width="62">2007</td>
<td width="161" >IZM</td>
<td width="124">6.142.42</td>
<td width="177">190000</td>
</tr>
<tr>
<td width="62">2007</td>
<td width="161" >IZM</td>
<td width="124">9.86.50</td>
<td width="177">10000</td>
</tr>
<tr>
<td width="62">2007</td>
<td width="161" >IZM</td>
<td width="124">12.43.250</td>
<td width="177">129000</td>
</tr>
</table>
� 
tbl_PRODUCT_GROUPS 
(This table gives the names to the product of the tbl_PRODUCTIONS table)
<table border="1" width="366" id="table3">
<tr>
<td>fld_PRODUCT_GROUP_CODE</td>
<td width="175">fld_PRODUCT_GROUP_CODE</td>
</tr>
<tr>
<td width="175">1.10</td>
<td width="175">Pencil</td>
</tr>
<tr>
<td width="175">1.20</td>
<td width="175">Rubber</td>
</tr>
<tr>
<td width="175">2.110.12</td>
<td width="175">Ruler</td>
</tr>
<tr>
<td width="175">12.128.43</td>
<td width="175">Pencil Box</td>
</tr>
<tr>
<td width="175">6.142.42</td>
<td width="175">School Bag</td>
</tr>
<tr>
<td width="175">9.86.50</td>
<td width="175">Pen</td>
</tr>
<tr>
<td width="175">12.43.250</td>
<td width="175">Calendar</td>
</tr>
</table>
� 
These 3 tables are in Oracle. I am trying to access the tables
with an asp page. I succeed to retrieve the values to a page, but processing the
values and joining the tables together is too complex for me. The table I want
is like this. Would you help me creating ASP page and SQL queries
to create this table:
Parameters to send the asp page that process the SQL queries: 
startdate=18.01.2007 
finishdate=20.01.2007
The Productions of -18.01.2007-20.01.2007
<table border="1" width="1066" id="table4">
<tr>
<td>Comes From tbl_PRODUCTIONS table</td>
<td>Comes From tbl_PRODUCT_GROUPS table</td>
<td width="155">Comes from tbl_ANNUAL_PRG table</td>
<td width="208">Comes from tbl_PRODUCTIONS table summing
each value for each product</td>
<td width="179">Comes from tbl_PRODUCTIONS table summing
each value for each product</td>
<td width="108">Comes from tbl_PRODUCTIONS retrieving the
values for "finishdate". Not cumulative like other values!</td>
<td width="187">Comes from tbl_PRODUCTIONS table summing
each value for each product</td>
</tr>
<tr>
<td>Producer Locations</td>
<td>Products</td>
<td width="155">Annual Production Program</td>
<td width="208">Production Program for wanted period</td>
<td width="179">Production Quantity for wanted period</td>
<td width="108">Stock Quantity</td>
<td width="187">Selling Quantity for wanted period</td>
</tr>
<tr>
<td width="119" >IST</td>
<td width="61">Pencil</td>
<td width="155">18000</td>
<td width="208">300</td>
<td width="179">304 </td>
<td width="108">100</td>
<td width="187">30</td>
</tr>
<tr>
<td width="119" >IST</td>
<td width="61">Rubber</td>
<td width="155">25000</td>
<td width="208">600</td>
<td width="179">590</td>
<td width="108">200</td>
<td width="187">162</td>
</tr>
<tr>
<td width="119" >ANK</td>
<td width="61">Ruler</td>
<td width="155">32000</td>
<td width="208">900</td>
<td width="179">1009</td>
<td width="108">450</td>
<td width="187">2235</td>
</tr>
<tr>
<td width="119" >ANK</td>
<td width="61">Pencil Box</td>
<td width="155">55000</td>
<td width="208">450</td>
<td width="179">461</td>
<td width="108">4664</td>
<td width="187">165</td>
</tr>
<tr>
<td width="119" >IZM</td>
<td width="61">School Bag</td>
<td width="155">190000</td>
<td width="208">300</td>
<td width="179">320</td>
<td width="108">234</td>
<td width="187">231</td>
</tr>
<tr>
<td width="119" >IZM</td>
<td width="61">Pen</td>
<td width="155">10000</td>
<td width="208">375</td>
<td width="179">365</td>
<td width="108">654</td>
<td width="187">240</td>
</tr>
<tr>
<td width="119" >IZM</td>
<td width="61">Calendar</td>
<td width="155">129000</td>
<td width="208">225</td>
<td width="179">230</td>
<td width="108">233</td>
<td width="187">303</td>
</tr>
</table>

OS: WinXP Pro
DB: Oracle (Version ?)
Script: ASP

View 4 Replies View Related

Couldn't Connect To Reports

Feb 6, 2007

Hi,

I'm not able to browse through http://localhost/reports.

When I'm trying to connect it gives me "Server Error in '/Reports' Application."At the same time I'm able to view Reportserver.At the same time I'm able to view Reportserver.(i.e)http://localhost/reportserver

please can anyone suggest me some solution to this problem..
Server Error in '/Reports' Application.

The trust relationship between the primary domain and the trusted domain failed.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.SystemException: The trust relationship between the primary domain and the trusted domain failed.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:

[SystemException: The trust relationship between the primary domain and the trusted domain failed.
]
System.Security.Principal.NTAccount.TranslateToSids(IdentityReferenceCollection sourceAccounts, Boolean& someFailed) +1167
System.Security.Principal.NTAccount.Translate(IdentityReferenceCollection sourceAccounts, Type targetType, Boolean& someFailed) +42
System.Security.Principal.NTAccount.Translate(IdentityReferenceCollection sourceAccounts, Type targetType, Boolean forceSuccess) +46
System.Security.Principal.WindowsPrincipal.IsInRole(String role) +205
System.Web.Configuration.AuthorizationRule.IsTheUserInAnyRole(StringCollection roles, IPrincipal principal) +120
System.Web.Configuration.AuthorizationRule.IsUserAllowed(IPrincipal user, String verb) +300
System.Web.Configuration.AuthorizationRuleCollection.IsUserAllowed(IPrincipal user, String verb) +191
System.Web.Security.UrlAuthorizationModule.OnEnter(Object source, EventArgs eventArgs) +3403086
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

View 11 Replies View Related

I Couldn't Find TRIM Function

Oct 18, 2006

Hi,

I found rtrim and ltrim functions, but I didn't find trim, so should I use rtrim(ltrim(' a ' ))? Am I right?

cheers,

Alessandro Camargo

View 5 Replies View Related

Which Queries Or Codes Couldn't Use In A Transactions In Sql Server

Feb 21, 2008

May i have a list of Which queries or codes couldn't use in a Transactions in Sql Server ?

View 6 Replies View Related

Why I Couldn't Run The Transfer Database Object Task With SQL Authentication

May 8, 2006

Hi all,

I have created a package to copy 10 tables from a database to another one. I have created a datasource with SQL Authentication mode. And it couldn't run until I changed the datasource connection to Windows Authentication mode. How could it be like that, it's just the authentication mode?

Is there anyone have the right answer for this situation?

View 3 Replies View Related

I Couldn't Access The Secondary Database After I Finished Shipping Configuration

Apr 19, 2006

Dear All

Please I need an urgent help

After i finished all Transaction Log Shipping Configuration.

I tried to use the database in the secondary database but i couldn't access it

i saw it in SQL Managment Studio as (Restoring......)

i tired to make a database snapshot from it , i had a message

Msg 1822, Level 16, State 1, Line 1

The database must be online to have a database snapshot.

Please urgently

View 1 Replies View Related

Couldn't Debug SQL By Step Into Stored Procedure On Server Explorer Of VS2008 (or VS2005) On Remote Machine

Oct 21, 2007

Hi all,

I couldn't debug SQL Server by "Step into Stored Procedure" on Server Explorer of VS2008 (or VS2005) to SQL 2005 Developer on remote Windows Server 2003 machine, it allway issue exception "Unable to start T-SQL Debugging. Could not attach to SQL Server process on 'Server'. Click Help for more information"

1) The environment:
The Client: Windows XP SP2 (WORKGROUP)
Visual Studio 2008 (or VS2005)

The SQL Server Machine: Windows 2003 Server Sp1 (DOMAIN)
SQL Server 2005 Developer

2) User account and Permission login:
I create the same user account for both Client and Domain Server with the same password, i also add that user to "Administrators" group in both machine.

At the SQL Server on Server machine, i added that account to ServerSecurityLogin with 'sysadmin' role already

3) Connection and authentication:
I used "Windows Authentication" for my connection to SQL server, and i checked sure my account of the connection by SQL command

SELECT SYSTEM_USER,
IS_SRVROLEMEMBER ('sysadmin')

4) Firewall:
I checked firewall like MSDN helping (i also tried to test by turn off firewall in both machine)

5) Visual Studio Remote Debugger:
I read "How to: Enable SQL Server 2005 Debugging" on MSDN with comment "The SQL Server can run on the same machine as the application or on a remote machine. If you are debugging T-SQL code only, then no remote setup is required."
so i didn't config Visual Studio Remote Debugger any thing.

Note: If i "Step Into Store Procedure" at Server locally, it works okey, so on at my PC client locally. But if i move debugging from my client to my Server, it occur error "Unable to start T-SQL Debugging. Could not attach to SQL Server process on 'Server'. Click Help for more information"???

If i execute store procedure on Server Explore, it works okey!

Please help me to find out what problem is???

Thanks,
Haiasc

View 2 Replies View Related

SQL 7 Replicate Then FTP ?

Aug 18, 2000

I am new (very new) to SQL. I 'm trying to set up SQL 7 to replicate a particular table on a daily schedule and then FTP the file out to a remote directory. Sounds easy! I'm sure it is, I just need someone to walk me through the steps.

If anyone can help me out I would really appreciate it.

View 2 Replies View Related

Why Can't Replicate?

Jul 9, 2004

Hi my friends,

I'm replicating with SQL Server 2000(updated Service Pack 3) get error:

SQL Server Enterprise Manager could not configure 'BREEZE1' as the Distributor for 'BREEZE1'.

Error 14113: Could not execute "'"C:program filesmicrosoft sql server80 ools\binnosql" -E -l60 -t60 -d"distribution" -b -i"c:MSDESQLBinnMSSQL\installinstdist.sql" -o"c:msdesqlinnmssql\installinstdist.out"'". Check 'instdist.out' in the install directory.
'distribution' is not configured as a distribution database.
Deleting database file 'c:msdesqldatamssqldatadistribution.ldf'.
Deleting database file 'c:msdesqldatamssqldatadistribution.mdf'.

I have a feeling this is failing because I have not C:msdesqlinnmssqlinstall directory at all.

Is there something I'm doing wrong...If the SP3 can affect???

View 1 Replies View Related

REPLICATE

Oct 4, 2007

This code :

declare @filenumber as char
set @filenumber = '65'

declare @filenu2 as char(6)

set @filenu2 = CONVERT(CHAR(6),(replicate('0',(6-len(@filenumber)))+ @filenumber ))

select @filenu2 as x

This should return 000065
but it returns 000006
i have stepped through it the replicate should replicate the 0 4 times
(6 - len of @filenumber) instaed its doing it 5 ??

View 8 Replies View Related

Can Not Replicate DDL Changes

Jun 6, 2007

Merge replication. We switched a publication over from push to pull and are now initiating everything within an application. We have just encountered a situation where it is now completely impossible to replicate DDL.

When this was a push subscription, we could execute the following and it would fly straight through the engine and hit every subscriber without having to do anything at all:

ALTER TABLE <tablename>

ADD <columnname> <datatype> NULL

Now that it is a pull subscription when I issue an ALTER TABLE and add a nullable column to the end of the table, it does NOT replicate at ALL. We get the following error message:

The schema definition of the destination table 'dbo'.'Player' in the subscription database does not match the schema definition of the source table in the publication database. Reinitialize the subscription without a snapshot after ensuring that the schema definition of the destination table is the same as the source table. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199478)
Get help: http://help/MSSQL_REPL-2147199478

The process was successfully stopped. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199481)
Get help: http://help/MSSQL_REPL-2147199481

It apears that we are now required to either reinitialize every subscriber every time we add a column or we are required to first distribute the DDL change to each subscriber, make sure they all have it, then add it to the publisher before anyone replicates, and then reinit every single one of them without a snapshot. This makes absolutely no sense at all.

The interesting thing is that we can add articles at will and those get applied with absolutely no problems at all to the subscribers without having to do anything other than add the article and generate a new snapshot.

Version 9.00.3042.00

View 8 Replies View Related

What Is The Best Way To Replicate Data?

Oct 18, 2006

Hi everyone, I've recently been thrown into a DBA role (I've never done any DBA work except writing a few SQL queries), so please go easy on me if these are stupid questions. My first task is to find the best way to replicate data between two SQL Server production databases. The data is to come from Production DB #1 to Production DB #2 (for access by a different system). The data has to be super-close -- not necessarily real-time, but within a few minutes. So when data is updated in #1, #2 shouldn't be be lagged by more than 45 minutes (5-10 is ideal). There are hundreds of thousands of records.What would be the best way to do this? Are there options in SQL Server 2005 to do "differential" updates from DB1 to DB2? Or is that how "transactional replication" works? If we were to implement a "full recovery model", will this impact any sort of replication? Thanks.

View 2 Replies View Related

Replicate To Laptops??

Mar 30, 2001

WE have a production database that we need to sync with about 100
salesman's laptops. These laptops will not always be online and
would need to sync on the fly.

We are thinking of having a separate distribution database to handle
the load and creating either a pull subscription or even just a DTS
package. We would like to have the salesmen just signon and go to an
ASP page and hit an Icon and either the pull subscription or the dts
package would start the sync..

Anyone tried this before and have any other ideas??

Thanks for any help??
SB

View 2 Replies View Related

Trans Rep Will Not Replicate

Jun 18, 2001

I have set up a simple trans rep from a server in the office to the web. both servers are NT4sp6aSQL 7.0. Tables only.

The publication and distribution db are on the server at the office, and there is a full time connection through the firewall.

The initialization and first replication works perfectly, but after that, there is a message from the snapshot agent that "no subscriptions needed initialization", the logreader says thare are no replicated transactions and the Distribution agent says there are no replicated transactions. What am I missing?

Thanks in advance

View 1 Replies View Related

What Is The Best Way To Replicate The Data?

Nov 15, 1999

Hi, there
I have a situation here....
I have Production DB and Development DB in the same SQL7.0 box....
I want to update the data and SP from Pro. to Dev at least once a day...
So this is my plan.

1. Back up(Pro.) and restore(Dev.) so I can have the same DB in the same box.
2. Using a Replication (Pulication and Subscription) ro update the data and SP.
3. Because DTS can not update the SP, I use the replication instead of DTS.
I need to update the SP, too..(Front end is ACCESS and backend is SQL7.0 DB)

Is there any other methods or way to make ti happen... Any suggestion can help...

Thanks in advance

Jay

View 2 Replies View Related

LogShip/Replicate

Jul 9, 2004

Can you have a database setup for both replication to server A and log shipping to server B?

Thanks,
Ken Nicholson

View 1 Replies View Related

Replicate MS SQL 6.5 DB In Oracle 10.2.0

May 27, 2007

Could someone please point me in the direction on where to look for info on how to:
Replicate an MS SQL 6.5 tables on an Oracle 10.2.0 server every 5-10min?

View 4 Replies View Related

How To Replicate Login Changes?

Aug 10, 2001

Hi:
In the publishing server, admin users could change and non-admin user password and also add login and drop login.

How could it happen to not only replicate the application database to subscriber server but also replicate the changes made in master database?
So that the remote subscriber server will have the most current login updates?

thanks
D

View 1 Replies View Related

Replicate Tables

Oct 18, 2007

Hi,

When I'm using MS SQL transactional replication and select all the tables to be replicated, some of the tables are marked with the red cross signs and aren't being replicated. How do I include these tables into the MS SQL replication? I tried to build indexes and re-created publications, but it didn't work.

Please help!

Thanks in advance,
-Alla

View 1 Replies View Related

How To Replicate A Database

Dec 3, 2012

Is any tool is available for replicating the Microsoft sql database..

View 1 Replies View Related

Replicate With New Table

Jan 30, 2007

Hi all, I have done the replication its working good.Now i have created the new table in publisher. but i have created the same table in sub scription too. how can i replcate this new table..?

Thanks
Krishna

View 3 Replies View Related

Replicate SPs And UDFs

Aug 2, 2007

Can changes made to replicated stored procedures (and User-defined Functions) on the Publisher update the Subscriber database?

If I ALTER a SP (or UDF) on Database1 with peer-to-peer Transaction Replication to Database2, will the alter replicate to the Subscriber(s)?

Thomas

ThomBeaux

View 10 Replies View Related

Replicate Prod To Dev

Oct 2, 2007

how do you design a dev box?
how do you replicate from prod to dev?
Ideas will be appreacited.

do you get a bak file and restore it?
DTS ?
linkservers?
???

=============================
http://www.sqlserverstudy.com

View 19 Replies View Related

Replicate To Local Pc

Jul 20, 2005

Hi !Hi !I'm thinking of installing a Microsoft SQL Server 2000 on a database server,to be the db of a webapplication, but the it must be possible for the usersto copy/replicate data from the server db, to a local db on their e.g.laptop to work even if not online. Is there a tool that can handle thisscenario. (it must be possible to update the server db from the laptop whenonline again ).And:What have to be installed on the laptop (apart from my application runningon the replicated data) ?Thanx/Hans

View 2 Replies View Related

Replicate Structure Only

Apr 26, 2006

I have a db and I only really need the table structures and defined functions/procedures from the db. A small sample set would be nice from each table, but not necessary.

What would be the easiest way to accomplish this?

I'm getting the db from a server not connected to the new one so I either need to get the files and reattach or I need to just copy the structure/procedures in.

thx

View 1 Replies View Related

Replicate Or Mirror

Feb 21, 2007

Hi,

Trying to build an replication and subscription beteween db in SQL 2000. The db holds our business system (Dynamics NAV, earlier Navision) and several of the tables include $, spaces and even :

We can take some of this away when creating a new db or make scripts for some actions but I wonder if the mirroring in 2005 could handle this?

Thanks,
Mikael

View 3 Replies View Related

How Do I Replicate New Tables, SPS From 2K To 2K5?

Aug 30, 2007

Hi,

I'm setting up Replication using SQL Server 2000 as a Publisher/Distributor and SQL Server 2005 as subscriber.

The problem I'm facing is when i add a new table in publisher (2K), it is not propagated to Subscriber (2K5).

How do i replicate new tables, or any database object (view, SP,etc) changes to Subscriber (2K5)?

Since I'm novice to Replication, can any one help me?

Thanks in advance.

Bharathi

View 1 Replies View Related

Command Replicate

Sep 1, 2006

I need to know if i can use command REPLICATE in sqlexpress2005

View 1 Replies View Related

How To Replicate A Database

Jan 23, 2008

My environment are Win Vista, Ms sql 2005 express, Ms Sql Server Management studio express. I have a database Mysearchdb.mdf and want to replicate Myseachdb.mdf to another database with exact same features. What is the best way to do it? I don't want to create each tables, functions and store procedures manually. Thanks

View 8 Replies View Related

Replicate Only Schema...

Sep 13, 2006

Hi,

I am relatively new to replication. I have a rather dumb question. I have two SQL Server databases, If i make a change in the first database schema, i want it to replicate to the second database. i dont want the data to replicate though. Is this possible?

Thanks,

Raj

View 3 Replies View Related