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 |
|
kkilpone
Starting Member
4 Posts |
 Posted - 2007-01-06 : 14:45:05
|
| HelloLooks like I'am the first one to pop this forum!But I'am a forward guy so lets get to the problem.A problem with my replication system as occured.I have a working SQL server that can do replication trough internet, everyting works The problem is when I try to import large amount of data (10000 rows) to my database on the SQL serverthe subscriber on my client don't get the rows. That will say imported data is not being replicated.only rows that i have manually inserted will be replicated.I used the import wizard that came with SQL server.Is there a solution to this problem? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-06 : 14:48:10
|
| How often does replication run?Peter LarssonHelsingborg, Sweden |
 |
|
|
kkilpone
Starting Member
4 Posts |
Posted - 2007-01-07 : 04:20:40
|
| The replication is done by demand.User makes the replication. This is used because laptops are not connected to internet all the time. |
|
|
|
kkilpone
Starting Member
4 Posts |
Posted - 2007-01-07 : 10:15:10
|
| PS. I'am using SQL mobile |
|
|
|
kkilpone
Starting Member
4 Posts |
Posted - 2007-01-07 : 14:22:43
|
| HiI found a solution to this problem!sp_addtabletocontents did the job for me. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-07 : 15:07:30
|
| Great feedback!Thanks.Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
import data from excel data sheets