| Author |
Topic |
|
tombino
Starting Member
26 Posts |
 Posted - 2007-04-15 : 22:38:38
|
| Hi, I have a SQL database in my server. One Software is using this database for editing /add / remove items in the database. I would like to put this database in the net (using ASP).How can I synchronize the SQL database in my server with the same one in remote?Appreciate your helpThanks!Tom |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-15 : 22:59:50
|
| Option are replication, log shipping or just backup/restore. |
 |
|
|
tombino
Starting Member
26 Posts |
Posted - 2007-04-16 : 00:36:08
|
| thank you. I will try replication. Tom |
|
|
|
tombino
Starting Member
26 Posts |
Posted - 2007-04-16 : 18:36:37
|
| Hi,Wich of this way is the best for just publish a part of the database. I need just a few tables and the database is huge, i dont want to make the website go slow.thanks.Tom |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-16 : 19:01:45
|
| Replication can do that.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
tombino
Starting Member
26 Posts |
Posted - 2007-04-16 : 21:31:04
|
| Hi,i have trouble to do the replication. I am reading the "SQL Server 2005 Books Online" but is a bit confusing. Wich is the first step that I have to do? I tryed to configure the distributor but becouse I want the the "Snaphot folder" to be online in an ftp folder a cant finish it. I tryed to add aa publisher in the "replication monitor" but come out this error:TITLE: Replication MonitorServer '64-BIT-SERVER' is neither a Publisher nor a Distributor, or you do not have permission to access replication functionality on this server.Tara, I sow your article about 32-bit/64-bit aliases, will be a problem in my case with my server at 64bit and a ftp server?Thanks.Tom |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-17 : 11:47:01
|
| Why do you need the snapshot folder to be an ftp folder? Who is giving you that requirement? You only have to do the snapshot once typically.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-17 : 14:13:39
|
| If it's one time data copy, can use export table wizard. |
|
|
|
tombino
Starting Member
26 Posts |
Posted - 2007-04-17 : 20:35:40
|
| is because it have to be alwais always synchronized in real time. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-17 : 21:57:06
|
| But that doesn't require the snapshot folder to be an ftp folder. Just setup transactional replication to be continuous.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
tombino
Starting Member
26 Posts |
Posted - 2007-04-19 : 02:42:42
|
| Thanks. i am trying to do it. I just didnt found where can i set up continuous in SQL 2005. |
|
|
|
tombino
Starting Member
26 Posts |
Posted - 2007-04-26 : 03:06:53
|
| ok, now I build the replication and is working in continuous mode. Now I still dont understand how can I publish it in the web...Appreciate your helpTom |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-26 : 12:53:05
|
| What do you mean "publish it in the web"?Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
tombino
Starting Member
26 Posts |
Posted - 2007-04-26 : 21:39:03
|
| I want to use some table of our database (stored in our server) in my website (ASP).We have a second SQL database in the web with the same data.The problem is that we have to type in the same information twice. One for our principal database one for the web. I was thinking if there is a solution for this.Thanks.Tom |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-26 : 22:34:20
|
| What do you mean 'database in the web'? Db in your web hosting company? Possible to set replication if your own sql server and your hosting company's sql server can talk to each other directly. |
|
|
|
tombino
Starting Member
26 Posts |
Posted - 2007-04-27 : 01:36:34
|
| Yes, i have literally the *.mdb file in the web server.May I have to ask my hosting company if is possible the replication setup.Tom |
|
|
|
|
synchronize sql