Pushing Data to Another SQL Server

Hi,
I have a production SQL2000 in Location A with Database A. I have another SQL2000 in Location B. I want to copy Database A to Location B. Any changes in Database A in Location A gets pushed to Location B.
Can I do this in 2000? TIAyes you can|||yes you can

Are you sure?

:D|||Are you sure?

:D

Absolutely ... the method of last resort would be sneakernet ... but I would try other M$oft methods built into SQL Server first.

Unless he meant seven years ago ... then I would have to say probably not.

:psql

Pull down from one table and push up into another....

Hi All,

I have a problem,

I need to copy a large amount of data from one table and insert it into another table.

The design of the destination table is exactly the same as the source table except for the fact that it has one extra field.
Can I copy; in a single SQL statement; all rows in one table (that match given criteria) into another table allowing for the extra field?What's "a large amount of data"?

INSERT INTO myNewTable99(Col1, Col2, ect)
SELECT Col1,Col2,ect
FROM myOldTable99
WHERE ...

You could also create a view, bcp the data out then in...|||OK - i see how that copies the old data across but what about the additional field?|||Oh and by a large amount of data i'm talking about 10,000 rows of data from a table of around 20 fields of various types.|||OK - i see how that copies the old data across but what about the additional field?

Just leave it out of the col list...unless it's not null

Then either add a 0 or '' or '12/31/9999' depending on the data type in the SELECT

and 10,000 is nothing...

Publishing SQL Express June CTP as a "Prerequisite"?

Hello,

I have not conducted extensive testing yet, but I have installed the June CTP of SQL Express and everything is working fine with my Beta 2 copy of VS.NET 2005. I see that "SQL Server 2005 Express Edition Beta" is listed in the "Choose which prerequisites to install" list of the VS.NET 2005 project settings for a basic Windows Forms Application.

My question is: Is this functionality expected to work fine in the Beta 2 for testing? Meaning, if I were to test publishing my app on a new test-copy of Windows XP Pro SP2, can I expect that in most cases it will deploy the June CTP components just fine?

Thanks much,

Sean H.If it does not work then its a bug and should be reported.

-Euan|||

FYI - From what I can tell this feature does (and yet does not) work with "ClickOnce" deployment and the publish feature. It seems that even though you can select SQL Express as a prerequisite and it does seem to install properly on test clients, it installs a previous version of SQL Express and not the June CTP.

I haven't investigated fully, but I get the error:

"The database 'C:\Test.MDF' cannot be opened because it is version 607. This server supports version 603 and earlier. A downgrade path is not supported."

.. when attempting to use the prerequisite publish feature with June CTP created databases. I would imagine this will be fixed in the final build.

For now, it seems ClickOnce publishing does not support the June CTP of SQL Express 2005.

|||I think this is because VS B2 understands the april CTP not the June CTP, this should be fixed for RTM.

-Euan|||

Do you know how to solve this problem without downloading a new version of SQL 2005

Thanks

Regards,Vincent

|||I think you will need a new version of VS and SQL Server Express if it does not work in the VS June CTP.

-Euan

Publication error ODBCBCP/Driver version mismatch

Hi.
I'm trying to setup a publication but I received an error:
The process could not bulk copy out of table 'cont20684C64E88B424BBBBE84921DEDFF77'.
I used the log to get more specific info and I got the following:
Microsoft SQL Server Snapshot Agent 8.00.760
Copyright (c) 2000 Microsoft Corporation
Microsoft SQL Server Replication Agent: MyServer-MyMainDatabase-MyMainDatabase2MyTargetDatabase-4
Connecting to Distributor 'MyServer'
Connecting to Publisher 'MyServer.MyMainDatabase'
Server:
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31

max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
[8/3/2005 4:43:30 PM]MyServer.MyMainDatabase: sp_MSgetversion
Initializing the publication 'MyMainDatabase2MyTargetDatabase'
*** [Publication:'MyMainDatabase2MyTargetDatabase'] Publication view generation time: 201 (ms) ***
*** [Publication:'MyMainDatabase2MyTargetDatabase'] Make generation time: 100 (ms) ***
Generating schema script for article '[ContactsCategories]'
Generating conflict schema script for article '[ContactsCategories]'
Generating referential integrity script for article '[ContactsCategories]'
Generating trigger script for article '[ContactsCategories]'
*** [Article:'ContactsCategories'] Time generating all schema scripts: 1762 (ms) ***
Generating schema script for article '[Contacts]'
Generating conflict schema script for article '[Contacts]'
Generating referential integrity script for article '[Contacts]'
Generating trigger script for article '[Contacts]'
*** [Article:'Contacts'] Time generating all schema scripts: 1292 (ms) ***
*** [System table:'MSmerge_contents'] .SCH script generation time: 10 (ms) ***

*** [System table:'MSmerge_tombstone'] .SCH script generation time: 20 (ms) ***

*** [System table:'MSmerge_genhistory'] .SCH script generation time: 21 (ms) ***

*** [System table:'sysmergesubsetfilters'] .SCH script generation time: 30 (ms) ***

[8/3/2005 4:43:34 PM]MyServer.MyMainDatabase: select 1 from [dbo].[ContactsCategories] (TABLOCK HOLDLOCK) where 1=2
[8/3/2005 4:43:34 PM]MyServer.MyMainDatabase: select 1 from [dbo].[Contacts] (TABLOCK HOLDLOCK) where 1=2
Bulk copying snapshot data for system table 'MSmerge_contents'
select * from cont20684C64E88B424BBBBE84921DEDFF77 where 1 = 2
[8/3/2005 4:43:35 PM]MyServer.MyMainDatabase: select * from cont20684C64E88B424BBBBE84921DEDFF77 where 1 = 2
SourceTypeId = 4
SourceName = MyServer
ErrorCode = 0
ErrorText = ODBCBCP/Driver version mismatch
The process could not bulk copy out of table 'cont20684C64E88B424BBBBE84921DEDFF77'.
Disconnecting from Publisher 'MyServer'

I have also found in another forum tha this is related with the files sqlsrv32.dll, sqlsrv32.rll and odbcbcp.dll. The versions of these drivers in my server are:
sqlsrv32.dll: 85.1025
sqlsrv32.rll: 81.9001
odbcbcp.dll: 81.9031
Is it really the problem in the versions of these files? Anyone knows how to update them and if there any risks by doing it?
Thanks in advance...

Try the link below to get started replication is one of the work in progress in SQL Server. Hope this helps.
http://www.replicationanswers.com/Default.asp