Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
adjones1980
Starting Member
36 Posts |
 Posted - 2009-12-11 : 05:21:52
|
| I have a table called DocStore in MainDatabase on a network server that has a FILESTREAM column.E.g.CREATE TABLE DocStore(ID uniqueidentifier not null,DocName nvarchar(50) not null,DocFileStream varbinary(max) FILESTREAM not null...)I have a matching table on LocalDatabase on a local SQLEXPRESS instance.If I used the following OPENROWSET command to transfer all records from MainDatabase to LocalDatabase will it fully transfer the FILESTREAM file to the local database of is there another step where I have to use a filestream Context like I would need to do if using ADO.NET?INSERT INTO LocalDatabase.dbo.DocStoreSELECT NetDB.* FROM OPENSROWSET('SQLNCLI','networkServer\namedInstance;Trusted_connection=true;','SELECT * FROM MainDatabase.dbo.DocStore') as NetDBI have to do this to several tables, each with several thousand records |
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2009-12-17 : 08:56:42
|
| Just try it on your test system.An infinite universe is the ultimate cartesian product. |
 |
|
|
|
|
|
OPENROWSET FILESTREAM between different servers