---The Question! Windows Synchronize Or Replmerg.exe To Be Or Be Not?---
Nov 22, 2006
How do you do! The Question of such plan There is server SQL Server 2005 Standard Edition and SQL Server Express, Between them is adjusted replication merge, on request pull, through web, on https. Podpischik in this instance SQL Server Express. So has here is noticed such particularity that when do synchronizing through Windows Synchronize manually, all pass fine, repeat same actions by means of being included in express utilities merge.exe? all ok. only when on publisher appears new articles, utility merge.exe refuses his(its) tighten appears the mistake:
2006-11-22 10:18:22.593 OLE DB Subscriber 'TERM0701SQLEXPRESS': sp_MSacquiresnapshotdeliverysessionlock2006-11-22 10:18:22.609 OLE DB Subscriber 'TERM0701SQLEXPRESS': sp_MStrypurgingoldsnapshotdeliveryprogress2006-11-22 10:18:22.625 OLE DB Subscriber 'TERM0701SQLEXPRESS': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}2006-11-22 10:18:22.656 Percent Complete: 02006-11-22 10:18:22.656 Snapshot will be applied from the alternate folder '\ReplSnapshotGAIuncREPL_TEST8_TEST820061122123965'2006-11-22 10:18:22.656 OLE DB Subscriber 'TERM0701SQLEXPRESS': sp_MSissnapshotitemapplied @snapshot_session_token = N'\replSnapshotGAIuncREPL_TEST8_TEST820061122123965', @snapshot_progress_token = N'\replSnapshotGAIuncREPL_TEST8_TEST820061122123965Table_2_21.sch'2006-11-22 10:18:29.468 OLE DB Subscriber 'TERM0701SQLEXPRESS': sp_MSreleasesnapshotdeliverysessionlock2006-11-22 10:18:29.484 The schema script 'Table_2_21.sch' could not be propagated to the subscriber.2006-11-22 10:18:29.500 OLE DB Subscriber 'TERM0701SQLEXPRESS': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}2006-11-22 10:18:29.531 Percent Complete: 02006-11-22 10:18:29.531 The schema script 'Table_2_21.sch' could not be propagated to the subscriber.2006-11-22 10:18:29.531 Percent Complete: 02006-11-22 10:18:29.531 Category:NULLSource: Merge Replication ProviderNumber: -2147201001Message: The schema script 'Table_2_21.sch' could not be propagated to the subscriber.2006-11-22 10:18:29.546 Percent Complete: 02006-11-22 10:18:29.546 Category:AGENTSource: TERM0701SQLEXPRESSNumber: 20143Message: The process could not read file '\ReplSnapshotGAIuncREPL_TEST8_TEST820061122123965Table_2_21.sch' due to OS error 1326.2006-11-22 10:18:29.546 Disconnecting from OLE DB Subscriber 'TERM0701SQLEXPRESS'2006-11-22 10:18:29.546 Disconnecting from OLE DB Subscriber 'TERM0701SQLEXPRESS'2006-11-22 10:18:29.562 Disconnecting from OLE DB Subscriber 'TERM0701SQLEXPRESS'2006-11-22 10:18:29.562 Disconnecting from OLE DB Subscriber 'TERM0701SQLEXPRESS'
Then and there start Windows Synchronize with the same parameter and all ok! New Article unrolled hereon not changing adjustment start the utility merge.exe? and mistakes no, forms such impression that utility merge.exe tightens only changes to data, or I have wrong exposed all keys under her(its) start, example of my calling the utility:
replmerg-Publisher Repl-PublisherDB Gai-Subscriber TERM0701SQLEXPRESS-SubscriberDB Gai-Publication ReplGAI-ValidateInterval 5-SubscriptionType 1-PublisherSecurityMode 0-PublisherLogin sa-PublisherPassword 111-SubscriberSecurityMode 0-SubscriberLogin sa-SubscriberPassword 111-SubscriberType 0-Distributor Repl -DistributorSecurityMode 0-DistributorLogin sa-DistributorPassword 111-FileTransferType 0-ExchangeType 3-AltSnapshotFolder \ReplSnapshotGAI-Output c:ErrorRepl.txt-LoginTimeout 30-InternetURL https://Repl/gai/replisapi.dll-InternetLogin ReplUserTerm -InternetPassword qwerty@123
that can be a mistake? rights on execution replication beside replmerg.exe and beside Windows Synchronize alike
View 1 Replies
ADVERTISEMENT
May 12, 2008
Can any one tell me
==> How can i connect my windows CE 5.0 divice to my SQL server 2005 database and synchronize the data.
==> i have tried using activesync 4.5. i am able to make the connection trough the activesync but it does not synchronize the data files.
==> what if i want to connect to the database from windows CE 5.0 divice.
Thanx
Harpreet
View 4 Replies
View Related
Feb 14, 2005
:eek:
OK, I'm having fun here. I have 3 anonymous subscribers using merge replication all, including the server, on SQL 2000 Server SP3a.
2 of the 3 subscribers crash during the merge process, a Dr Watson error log comes up saying that the replmerg.exe has died.
I have checked for orphaned processes of the same name to no avail. Just in case I made a mistake, I rebooted the server to ensure that any orhpaned processes were killed. No Joy.
Does anyone have any idea what this would happen?
View 2 Replies
View Related
Dec 20, 2005
Hello,
On an existing Merge Pull Subscription (Subscriber: SQL Express) via websync how can we start replication via vb.net? We can use the cmd line replmerge.exe and all works fine however we would like this to be cleaner as it's going to be on demand sync. I saw in BOL about the RMO and how to create pubs/subs but nothing telling me how to actually start the replication process. Is there a sample of how to start the replication process in vb.net for websync? Thanks in advance.
John
View 17 Replies
View Related
Mar 23, 2007
Hello,
I tried to use REPLMERG utility for Web synchronization and got the following error message in log file:
2007-03-23 14:35:10.484 The subscription to publication 'X' could not be verified. Ensure that all Merge Agent command line parameters are specified correctly and that the subscription is correctly configured. If the Publisher no longer has information about this subscription, drop and recreate the subscription.
The case description is as the following:
REPLMERG utility command line:
"C:Program FilesMicrosoft SQL Server90COMREPLMERG.EXE" -ExchangeType 3 -Publication X -
Publisher B01 -Subscriber 127.0.0.1SQLEXPRESS -Distributor B01 -PublisherDB DBS -
SubscriberDB DBS -PublisherSecurityMode 1 -Output C:TempDBS.log -OutputVerboseLevel 2 -
SubscriberSecurityMode 0 -SubscriberLogin Operator -SubscriberPassword XXX -
SubscriptionType 2 -DistributorSecurityMode 1 -Validate 3 -InternetURL
https://www.company.com/Synch/replisapi.dll -InternetSecurityMode 0 -InternetLogin USER1 -
InternetPassword PWD1 -SubscriberType 0
The subscription to the publication X has been created with the following T-SQL script:
USE DBS
EXEC sp_addmergepullsubscription
@publisher = N'B01',
@publication = N'X',
@publisher_db = N'DBS',
@subscriber_type = N'anonymous',
@sync_type = N'automatic',
@subscription_priority = 0.0;
I've also tried to check subscription information on the server 127.0.0.1SQLEXPRESS using the following:
sp_helpsubscription_properties N'B01', N'DBS', N'X'
but the result set is empty. When I run sp_helpsubscription_properties
I get the same empty result. But the subcription is anonymous and when I synchronize it using RMO - it works.
Could you please advice what could cause the problem?
Thank you.
Alexander.
View 16 Replies
View Related
Mar 23, 2004
I have two customer tables in SQL Server, but some of the field names are not the same, that I need to synchronize. Here is how they are structured: (Table 1 is old and Table 2 is new)
Table 1 (900 records)
---------------
cust_code
cust_shipto_code
cust_shipto_name
cust_email
Table 2 (700)
---------------
custcode
loccode
custname
custemail
1. First I need to find out what records exist in Table 1 but not in Table 2 and add them to Table 2.
2. Secondly, I need to then find all records in Table 1 that match the records in Table 2 and update the Email address in Table 2 with the data from Table 1.
Any suggestions on how to do this sync?
View 3 Replies
View Related
Mar 24, 2004
I am tryign to sync two tables that are in two different databases. It is suppuse to update the record in the [orgloc] table if the customer ship to name has changed in the [opcshto] table. The cust_code would be the unique identifier. in both tables.
this is what I have:
UPDATE [r2lprospector].[dbo].[orgloc]
SET [r2lprospector].[dbo].[orgloc].[custshiptoname] =
[cimpro1].[dbo].[OPCSHTO].[cust_shipto_name]
from [cimpro1].[dbo].[OPCSHTO], [r2lprospector].[dbo].[orgloc]
WHERE [cimpro1].[dbo].[OPCSHTO].[cust_code] = [r2lprospector].[dbo].[orgloc].[custcode]
I keep getting an error though. The error is:
Server: Msg 8152, Level 16, State 9, Line 1
String or binary data would be truncated.
The statement has been terminated.
Any help is appreciated.
View 1 Replies
View Related
Apr 15, 2007
Hi,
I have a SQL database in my server. One Software is using this database for editing /add / remove items in the database. I would like to put this database in the net (using ASP).
How can I synchronize the SQL database in my server with the same one in remote?
Appreciate your help
Thanks!
Tom
View 15 Replies
View Related
Sep 11, 2007
Hello, I have 3 tables with their columns: [Articles] > ArticleId, ArticleText [Categories] > CategoryId, CategoryText [CategoriesInArticles] > ArticleId, CategoryId I created a stored procedure that has the following inputs: ArticleId, ArticleCategories ArticleCategories is of type NVARCHAR(Max) and has categories in CSV format: "Category A, Category B, Category C" I have a function, CSVTable, that creates a table with all the categories. I need to make a kind of synchronization: >
Update all categories for the given ArticleId. If any Category is no
longer associated with any ArticleId (In CategoriesInArticles) then
remove it from table Categories.
View 4 Replies
View Related
Sep 13, 2007
Hi,
I am trying to create a type of synchronization but I am having a lot of problems to make this work.
I have 3 tables:
CREATE TABLE Articles (ArticleId INT, ArticleText NVARCHAR(512))
CREATE TABLE Categories (CategoryId INT, CategoryText NVARCHAR(512))
CREATE TABLE CategoriesInCategories (ArticleId INT, CategoryId INT)
Consider the following tables content:
Articles Table
ArticleId ArticleText
1 Game ended 1-1
2 Book Review
Categories Table
CategoryId CategoryText
1 Sports
2 Entertainment
CategoriesInArticles Table
ArticleId CategoryId
1 1
2 2
I need to create the following procedures:
CreateArticle
Create Procedure [CreateArticle]
@ArticleText NVARCHAR(512),
@ArticleCategories NVARCHAR(MAX)
As
Begin
...
End
This procedure should the the following:
1. Create the article in table Articles
2 .Use the function CSVTable that returns a table with all the categories contained in @ArticleCategories.
For each category check if there is already one with the same CategoryText in table Categories.
If there is just get the CategoryId and add a new record into CategoriesInArticles with ArticleId and found CategoryId.
If there isn't any then create the new Category into table Categories and then add the new record to CategoriesInArticles.
DeleteArticle
Create Procedure [DeleteArticle]
@ArticleId INT
As
Begin
...
End
This procedure should the the following:
1. Delete the article in tables Articles and CategoriesInArticles given its ArticleId
2 .Delete categories from table Categories that are no longer associated with any other article (in table CategoriesInArticles)
UpdateArticle
Create Procedure [UpdateArticle]
@ArticleId INT,
@ArticleText NVARCHAR(512),
@ArticleCategories NVARCHAR(MAX)
As
Begin
...
End
This procedure should the the following:
1. Update the values into Articles Table
2 .Use the function CSVTable that returns a table with all the categories contained in @ArticleCategories.
I think the easiest way is to delete all the categories from ArticleId as it is done in DeleteArticle.
Then It creates the new categories as it is done in CreateArticle.
Consider I create a new article:
EXEC CreateArticle @ArticleText = "Book launched at sports event" @ArticleCategories = "Entertainment, Business"
The tables would become:
Articles Table
ArticleId ArticleText
1 Game ended 1-1
2 Book Review
3 Book launched at sports event
Categories Table
CategoryId CategoryText
1 Sports
2 Entertainment
3 Business
CategoriesInArticles Table
ArticleId CategoryId
1 1
2 2
3 2
3 3
NOTE: Because there is no category named Business in Categories this must be created.
Then I would updated it:
EXEC UpdateArticle @ArticleId = "3" @ArticleText = "Book launched at sports event" @ArticleCategories = "Sports, Tech"
The tables would become:
Articles Table
ArticleId ArticleText
1 Game ended 1-1
2 Book Review
3 Book launched at sports event
Categories Table
CategoryId CategoryText
1 Sports
2 Entertainment
4 Tech
CategoriesInArticles Table
ArticleId CategoryId
1 1
2 2
3 1
3 4
Note: Since Business category is no longer used by any other article then it is also deleted from Categories.
The new Tech category is then created and associated with the updated article as well as the existing category Sports.
Finally I would delete it:
EXEC DeleteArticle @ArticleId = "3"
The tables would become:
Articles Table
ArticleId ArticleText
1 Game ended 1-1
2 Book Review
Categories Table
CategoryId CategoryText
1 Sports
2 Entertainment
CategoriesInArticles Table
ArticleId CategoryId
1 1
2 2
Note: Since Tech category is no longer used by any other article then it is also deleted from Categories.
The Sports category is not deleted from Categories since it is used by Article with Id=1
Well, I hope I didn't miss anything and I explained it well.
I have been trying my code, either by creating a separate procedure named SynchronizeCategories or inside the Create, Delete and Update procedure.
Until now I was not able to make this work.
Here is the code I use in my SynchronizeCategories procedure:
INSERT INTO CategoriesInArticles(CategoryId, ArticleId)
SELECT c.CategoryId, @ArticleId
FROM Categories c INNER JOIN CSVTable(@ArticleCategories) ac
ON c.CategoryText = ac.String
LEFT JOIN CategoriesInArticles cia
ON c.CategoryId= cia.CategoryId
WHERE cia.CategoryId IS NULL
INSERT INTO Categories(CategoryId, CategoryText)
SELECT cia.CategoryId, NULL
FROM CategoriesInArticles cia
JOIN [Categories] c ON c.CategoryId = cia.CategoryId
INNER JOIN CSVTable(@ArticleCategories) ac ON ac.String = c.CategoryText
WHERE c.CategoryId IS NULL
DELETE c
FROM Categories c
INNER JOIN CSVTable(@ArticleCategories) ac ON ac.String = c.CategoryText
LEFT JOIN CategoriesInArticles cia ON c.CategoryId = cia.CategoryId
WHERE cia.CategoryId IS NULL
Could someone, please, help me out with this?
Thank You Very Much,
Miguel
View 4 Replies
View Related
Apr 17, 2008
Please can somebody help me with the following:
Our company has an enterprize site (a very large one). From time to time we need to make changes in it. In other words, we had to synchronize one database (local where we make all changes) and database on hosting. So, we did it manually (wrote scripts and inserted them in database on hosting). But as the databases grew it became impossible to synchronize everything manually. So we need some tool which could cope with this task. The problem is that, as I know, there are many tools which can do it, but we are tight in time and can't evaluate them all. Please share your ideas on what tool is worth evaluating?
Thanks in advance.
View 9 Replies
View Related
Dec 30, 2003
Please we need help in the next Scenario:-
- Head office SQL Server 2000 including main database (huge db for about 8 systems).
- 8-10 branches with small database (for 3 systems only).
- No connection available between all offices.
1- In daily basis we need to transfer all transaction updates done in all offices to update the main database in head office.
2- After updating head office we need to transfer the last case in 2 or 3 tables to all offices again.
3- There are some common tables, managed in head office only (usually not changed), in case this tables changed for enhancement or anything else, we need to transfer this change to all offices.
NOTE: No connection available every where, therefore we need hand carry solutions as soon as possible and please tell me in details as you can because the time is too short.
View 6 Replies
View Related
Aug 8, 2005
Using a web interface, I am placing text into a SQL database. From timeto time, I would like to synchronize one of my other tables in thedatabase with the table that I am inserting content into. What is theSQL command to synchronize these tables? I will be initiating thiscommand through a web interface, so I cannot use enterprise manager.Thank you very much!
View 4 Replies
View Related
Apr 5, 2006
I want to replicate my database with table like this:+-----------------+
| Table |
+-----------------+
| ID |
| Distributor ID |
| Total Sales |
| ... |
+-----------------+
At table above you can see that I have a field called Distributor ID. The scene like this, I have 4 distributor that have replication of my database. Each day they synchronize database from distributor (lets call they A, B, C, D) into my server. So at the server have data with Distributor ID A, B, C, D. But if an distributor want to download its data from my server, they only have data with their ID, for example distributor A have synchronize their data with me and now want to download the data from me, so I only send data that only contains Distributor ID A, so that A can not see data from other distributor (B, C, D) that rule also applied for B, C, and D.
The summary simple like this, I have all Distributor data (data from A, B, C, D) but each distributor only have their own data if they download from me, A only have A data, B only have B data, so on).
Thank you.
View 1 Replies
View Related
Aug 4, 2006
I am new the Replication service.
If I have 2 server A and B. A has a table named "Table1" and B has a table named "Table2". The schema of table is same.
Could I do the replication (E.g. snapshot) from A Table1 to Table2 in B? If yes, how?
Thanks.
View 1 Replies
View Related
Mar 29, 2006
Hello,
I have an Access database that updates each 5 minutes with data from a weather station. As you can imagine the access database is becomming huge, so I would like to get that data into SQl Express to make queries faster and better connectivity with visual webdeveloper.
There is no way I can get the data directly into the SQL Express database, as the vendor only supplies a tool for MySQL and access through odbc.
Is there a way to sync the access database and my SQL Express each 5 minutes?
And off course not manual
Thank you...
View 4 Replies
View Related
Mar 17, 2006
I am attempting to follow the example from VB.NET 2005 on synchronizing and SQL Database and an SQL Mobile 2005 db.
I have verified that the PALM device (Treo running WM 5) when the device is connected to my desk top by using IE on the Palm to browse to the shared Folder I set up with IIS and the Configuration Web Synchronization Wizard.
The error I get is "An incorrect or unsupported HTTP function call was made." and I have not been able to find any referiences to this error directly related to SQL M 05.
Any help wil be greatly appreciated.
Thanks
View 22 Replies
View Related
Nov 8, 2006
Hi,
I have a little problem. I need to synchronize data from two tables with different table structures meaning they may or may not have the same column name and/or table name. I have read a lot of midware tools which I can use but is there a way inside sql server where I can do this? And this synchronization should be automated. Like when I update one table, it will automatically update the other table with the data that was changed. I know I can manually update the records but is there an automated way that I can do this? I have also read about integration technologies supported by sql server like ssis and replication but it seems complicated and I dont have the luxury of time to learn these. But if these can be the answer to my questions then I guess I dont have a choice. Please help. Newbie in sql. Thanks!
View 1 Replies
View Related
Apr 29, 2005
I made application (using .NET) to transfer data using PDA via GPRS and
then upload data to database server. The data not update old data but make
new insert new data to database server.
If we use USB to synchronize data from PDA to database server, we can use merge
replication. But i still confused how to synchronize data, if we transfer data from
PDA via GPRS, then insert to database server???
Regards
Agus Ilmi
View 1 Replies
View Related
Apr 29, 2005
I made application (using .NET) to transfer data using PDA via GPRS and
then upload data to database server. The data not update old data but make
new insert new data to database server.
If we use USB to synchronize data from PDA to database server, we can use merge
replication. But i still confused how to synchronize data, if we transfer data from
PDA via GPRS, then insert to database server???
Regards
Agus Ilmi
View 1 Replies
View Related
Jul 18, 2007
Hi,
First post on the site, yippee! So first of all I'm not a DB pro but occasionally need to hire someone, and to do this properly I need to understand the basic workflow.
Could really use some advice on comparing and synchronizing 2 different SQL databases in different geographical locations..... need updates from website A SQL database to be automatically updated to website B in as close to real time as possible. The whole database doesn't need to be transferred every time, only specific information regarding personal profiles and their activity on the other site. The end result would be that users can login to their profiles any time on either website and see up-to-date reports on their activities/results.
I know it would be much easier to host both databases on the same server but for various reasons this is not an option.
The past day was research into all the various SQL DB synch software. Having a hard time finding unbiased viewpoints...
First of all is there any reliable and secure open source alternatives? I searched sourceforge and found 'SQL Server DB Compare and Synchronize', but it doesn't seem to have full automation.
Also found a few paid for solutions through other forums such as 'Red Gate' products but they would cost upward of $3-500
I need something that is secure and reliable, don't mind a bit of customization but would prefer a solution out of the box.
any advice/articles/reading material/recommendations would be greatly appreciated
have a nice day :) Derek
View 5 Replies
View Related
May 8, 2008
Hi,
I have the following scenario:
There are 3 web applications in a local network which all have a local copy of the same database. Each of them can alter their local database (just the data, not the structure), and every time that happens the databases of the other applications should be updated immediately.
Are there any solutions out there for that? I found that most tools like slony only mirror one master database to multiple slaves, but I want every database to be able to be the starting point.
There could also be a central sync server, like in subversion..
Greets,
Patrick
View 3 Replies
View Related
May 13, 2008
Hi,
I have a scenario which I need to implement at my work.
I need to maintain one Central SQL Server DB and multiple non central SQL Server DBs at different locations. Here the same DB schema is maintained at Center & non Central SQL Servers. The requirement is: each non central DB has to synchronize with the central DB and has to update the Central DB with the changes made locally.
Here the challenge is the intermittent connectivity between the DBs. The connection is not guaranteed to be alive 24 hours a day. It may go down frequently also. I would like to know the possible ways to handle my situation (i.e. synchronization). And also please suggest me if there is any support with the SQL Server DB itself.
Thanks,
Kishore
View 3 Replies
View Related
Mar 22, 2007
i have 2 DB in 2 different servers.
db1 and db2
db1 gets 150k records every hour. db2 is like the backup of db1. db2 is used to retrieve records to create reports using reporting services.
what is the best way to synchronize db2 with db1?
is it to create a dts package and set up a job that runs every hour?
off topic question.
what kind of language does reporting services use to create the reports?
View 2 Replies
View Related
Apr 24, 2007
i have 2 db's that are totally different except that they both have a table users and I want to make it that anytime the user table is updated or added to in one db - that it is copied over to the other db.
is this possible?
View 9 Replies
View Related
Jul 23, 2005
Hi, anybody can help me.How can i synchronize 2 tables on 2 different sql servers 2000i mean TABLE1(col1, col2, col3, col4) andTABLE1(col1, col2, col3, col4, col5, col6)the first 3 colums are the same in rwo tables.Thanks--Message posted via http://www.sqlmonster.com
View 6 Replies
View Related
Mar 29, 2006
What is the easiest way to synchronize all data and database objects between my development machine and hosting server? Is there any SSIS free script I can use?
View 7 Replies
View Related
Feb 14, 2008
Hi,
I have decided to use CLR Triggers to synchronize data between two different tables but I have a problem. The scenario is this. I do an insert in Table1. Table1 firest the trigger which then inserts a record in Table2. The trigger in Table2 fires a trigger which does an insert to Table1 again.
I need to find a way to disable the trigger so that it will not go in an infinite loop when I insert a record in either of the tables. What I have done so far is to disable Table2's trigger before I commit my insert to Table2 so that Table2's trigger won't fie. I will then enable the trigger after the insert is committed. Also, I have a webservice which manages the inserts/updates/deletes. I call webmethods from this webservice in my clr triggers.
Help please!
Thanks,
Ryan
View 5 Replies
View Related
Jul 16, 2007
Hi,
What is the best way to have native win32 code tell SQL Server 2005 Express to synchronize for merge replication? What API should I use? Should I exec the distrib.exe and/or replmerg.exe command line utilities? Should I use "Windows Synchronization Manager"? Are they other options?
Thanks,
Bryan
View 4 Replies
View Related
Apr 11, 2008
Hi everyone,
I would like to know if using Service Broker to synchronize another non MS DB with this technologie is suitable?
My idea is to place in messages the modification of any table and then have a windows service or web service to read this Service Broker Messages, and then update another database (Intersystems Caché).
Any other ideas are welcome!
Best regards,
Sam
View 3 Replies
View Related
Apr 10, 2006
Hi,
I was wondering if the following is possible: I have 2 SQL Express servers on different machines. One holds the production and one the development database. On a request basis I'd like mirror all the data of the production database to the development database. Right now I have to stop the sql engine, zip the mdf, send it over, attach it to database, etc. and that's quite cumbersome. So, is there an easier way to do this? If not with SQL Express, is it possible with the full version?
Thanks,
Tom
View 1 Replies
View Related
Feb 22, 1999
Hello:
Next week I have a database going into production and now I need to set up
a separate reporting database. This is no problem except that I'll probably
need to load data daily from production into the reporting database.
My questions:
1) Can I trust the EM transfer manager to refresh the data nightly in the
reporting database? Will it truncate the pre-existing data.
2) Must I be logged into the reporting database(destination) always or
should I incorporate that into a script? How?
3) Has any one experienced any problems using transfer manager for this
purpose?
4) What alternative should I use? bcp?
Thanks.
DAvid Spaisman
View 1 Replies
View Related
Feb 18, 2002
Hi,
I have tried to synchronize master..sysxlogins table from production server to
a testing server. All the databases in the testing server will be loaded from the production server. In order to save drop and recreate the database's users in every database restore, I have tried to find out a quick way to synchronize the sysxlogins table. However, when I load the sysxlogins from the production server onto the tempdb in the testing server, I get the following error :
Server: Msg 213, Level 16, State 5, Line 1
Insert Error: Column name or number of supplied values does not match table definition.
Any comment and suggestion is highly appreciated.
Thanks
The table structures (output of sp_help) of the temporary table and master..sysxlogins are as follows :
1. sp_help testjoe4
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- ---------------------------
testjoe4 dbo user table 2002-02-19 15:27:31.930
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
srvid smallint no 2 5 0 yes (n/a) (n/a) NULL
sid varbinary no 85 yes no no NULL
xstatus smallint no 2 5 0 no (n/a) (n/a) NULL
xdate1 datetime no 8 no (n/a) (n/a) NULL
xdate2 datetime no 8 no (n/a) (n/a) NULL
name sysname no 256 yes (n/a) (n/a) SQL_Latin1_General_Pref_CP1_CI_AS
password varbinary no 256 yes no no NULL
dbid smallint no 2 5 0 no (n/a) (n/a) NULL
language sysname no 256 yes (n/a) (n/a) SQL_Latin1_General_Pref_CP1_CI_AS
isrpcinmap smallint no 2 5 0 yes (n/a) (n/a) NULL
ishqoutmap smallint no 2 5 0 yes (n/a) (n/a) NULL
selfoutmap smallint no 2 5 0 yes (n/a) (n/a) NULL
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------- ---------------------------------------- -------------------
No identity column defined. NULL NULL NULL
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
The object does not have any indexes.
No constraints have been defined for this object.
No foreign keys reference this table.
No views with schema binding reference this table.
2. sp_help master..sysxlogins
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- ---------------------------
sysxlogins dbo system table 2000-08-06 01:29:12.500
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
srvid smallint no 2 5 0 yes (n/a) (n/a) NULL
sid varbinary no 85 yes no no NULL
xstatus smallint no 2 5 0 no (n/a) (n/a) NULL
xdate1 datetime no 8 no (n/a) (n/a) NULL
xdate2 datetime no 8 no (n/a) (n/a) NULL
name sysname no 256 yes (n/a) (n/a) SQL_Latin1_General_Pref_CP1_CI_AS
password varbinary no 256 yes no no NULL
dbid smallint no 2 5 0 no (n/a) (n/a) NULL
language sysname no 256 yes (n/a) (n/a) SQL_Latin1_General_Pref_CP1_CI_AS
isrpcinmap smallint yes 2 5 0 yes (n/a) (n/a) NULL
ishqoutmap smallint yes 2 5 0 yes (n/a) (n/a) NULL
selfoutmap smallint yes 2 5 0 yes (n/a) (n/a) NULL
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------- ---------------------------------------- -------------------
No identity column defined. NULL NULL NULL
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ncsysxlogins nonclustered located on PRIMARY srvid, sid
sysxlogins clustered, unique located on PRIMARY srvid, name, sid
No constraints have been defined for this object.
No foreign keys reference this table.
Table is referenced by views
--------------------------------------------------------------------------------------------------------------------------------
View 1 Replies
View Related
