problem importing database

[furmanov]

BSD
Dear Sirs
I try to import a database into Web Data Adminitrator from one computer to another and I get an error message

Line 1: Incorrect syntax near '»'.

PLEASE HELP
what do i do?
daniel

 

[mrdenny]

What are you using to import, what is the script that you are running, can you post the code that is doing the import?

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[furmanov]

Hi
thanks for the reply. i export in the Microsoft Web Data Administrator in one computer, then copy the file to another computer, and there I import also using the Microsoft SQL Web Data adminitrator. It can be found

http://www.microsoft.com/sql/msde

i use no scripts, just the option in the program
bye
daniel

 

[mrdenny]

Do you are exporting from a SQL server then importing into another SQL Server? Why not just setup a linked server between the servers and copy the data directly across?

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[furmanov]

thansk for the reply. how do i setup the connection and transfer the data the way u said? second, sometimes it is for a computer in a diferent location, so we found export and import the easiest way. how do i solve it?