Hi all,
I was wondering if anyone can tell me this.
I am using BCP to do my data transfer from SQL65 to SQL7.
The statement is like:
bcp TableName out “outfile.txt -e "C:\Temp\bcp\sql_err.txt"
-b 10 -n -6 -q
-S "ServerName"...
Hi all,
I have set up a bcp process. This is bcping between a SQL65 to SQL7. I noticed that the database has a few image field and binary field. Does bcp copy over binary data also?
I used the following
bcp filename out -c -6 ....
the -c is to say I will be using char type to transfer...
Hi everyone,
Just a quick question. I am trying to do a DTS to pull data across the network from a database on one server to another.
The database has many tables. There are 3 owners to the tables. Owner1 owns 1/3 of the tables and Owner2 owns 1/3 and Owner3 owns 1/3. Some table names are the...
Hello everyone,
Could someone tell me what I have to do to remove fully replication from my SQL65. I have removed it using the "remove replication" menu option.
But when i re-enter the program, it still has the distributor properties and subscriber database.
It also complains, when...
Hi everyone,
Can anyone tell me if they have had any success on replicating SQL Server.
I have ServerA with SQL65 and ServerB with SQL7. ServerA is set up as a publisher and ServerB as the Subscriber.
I have had alot of problems with this setup. I cant set it up, though I am able to set up...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.