FTP replication other 2 sql server 2000 (without IIS)

Hi everybody,
I want to setup a FTP replication ( snapshot or transactionnal) other 2
SQL 2000 server ( S1 and S2) accross non trust domains ( domain A and
domain B).
neither S1 , nor S2 can have IIS set. So i want to use an FTP server on
domain B to acts as snapshot folder.
Do you have some advices allowed me doing this.
RM : I read lots of method that use IIS on the publisher , but I can't
because neither S1 nor S2 can be reached other the web.
Thank you for reading me.
You can park your ftp server anywhere on your network as long as the
publisher and subscribers can reach it. The Publisher will have to be able
to do a local copy to a local drive or a network drive, so it will need
read, list files and folders, and write rights to the share or folder which
the ftp server is on. The subscriber will merely need to be able to access
the ftp site.
HTH
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<philippe.edmond@.gmail.com> wrote in message
news:1164819189.753714.312780@.h54g2000cwb.googlegr oups.com...
> Hi everybody,
> I want to setup a FTP replication ( snapshot or transactionnal) other 2
> SQL 2000 server ( S1 and S2) accross non trust domains ( domain A and
> domain B).
> neither S1 , nor S2 can have IIS set. So i want to use an FTP server on
> domain B to acts as snapshot folder.
> Do you have some advices allowed me doing this.
> RM : I read lots of method that use IIS on the publisher , but I can't
> because neither S1 nor S2 can be reached other the web.
> Thank you for reading me.
>
|||Thanks for your response.
I will try it.
On 29 nov, 18:12, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:[vbcol=seagreen]
> You can park your ftp server anywhere on your network as long as the
> publisher and subscribers can reach it. The Publisher will have to be able
> to do a local copy to a local drive or a network drive, so it will need
> read, list files and folders, and write rights to the share or folder which
> the ftp server is on. The subscriber will merely need to be able to access
> the ftp site.
> HTH
> --
> Hilary Cotter
> Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com
> <philippe.edm...@.gmail.com> wrote in messagenews:1164819189.753714.312780@.h54g2000cwb.g ooglegroups.com...
>
>
>
>

from MSSQL server to MySQL

Hi everybody,

I have to port a database from MSSQL to MySQL.
I'm really a newbie with MSSQL and I need some hints on how to do this task.

I received a .bak file which my boss told me that this a backup of the database
I have to port.

Then I installed MSQL 2000 developer edition on my workstation and then started
playing with it.

The problem is that I don't know how to connect to the database... and with what
application do some queries. In mysql I use phpMyAdmin which is really useful.
Is there something similar for SQL server? Or something like sqlplus under Oracle?

Moreover how can I install the .BAK file they sent me on my MSSQL install in order
to recreate the db on my workstation??

Thank you.

Fabio1.Start-->Programs-->Micrsoft Sql Server-->Enterprise manager(click)

2.right click on databases--> All tasks--> Restore Database
3. Enter database name,select 'From Device' -->Select Device--> Add
and map to ur backup file (.bak)|||Hi everybody,

I have to port a database from MSSQL to MySQL.
I'm really a newbie with MSSQL and I need some hints on how to do this task.

I received a .bak file which my boss told me that this a backup of the database
I have to port.

Then I installed MSQL 2000 developer edition on my workstation and then started
playing with it.

The problem is that I don't know how to connect to the database... and with what
application do some queries. In mysql I use phpMyAdmin which is really useful.
Is there something similar for SQL server? Or something like sqlplus under Oracle?

Moreover how can I install the .BAK file they sent me on my MSSQL install in order
to recreate the db on my workstation??

Thank you.

Fabio

use query analyser for writing the queries its similar to sqlplus but alot more rich in features.
to restore the database use enterprise manager. refer BOL for more info.|||ok.. thank you all.
I understood the steps.. but I'm getting an ugly error...

The backup of the system database on device BackupExecSqlAgent_master_00 cannot be restored because it was created by a different version of the server (134218262) than this server (134217922).

Seems that my db version is older than the one I have.
Seems that I have to install some upgrades to my server..

How can I do this?

Thanks
Fabio|||Nobody has ideas??

I'm still stick on this...

Thanks...|||ok.. thank you all.
I understood the steps.. but I'm getting an ugly error...

The backup of the system database on device BackupExecSqlAgent_master_00 cannot be restored because it was created by a different version of the server (134218262) than this server (134217922).


Seems that my db version is older than the one I have.
Seems that I have to install some upgrades to my server..

How can I do this?

Thanks
Fabio

tell me more abt the .bak file u got.From which datbase u got the back up,what version etc|||the .bak file is a backup made by a hosting company which runs mssql 2000.
The problem seems to be that they run a different release of mssql 2000 than mine.
(probably a service pack release or something similar)

Then when I try to load the database it hangs with that error..

Sorry but I don't know what else tell you...
If you need more information you can ask..

Thank you a lot|||why dont u install latest service pack and try.U can download latest service pack from microsoft.|||Thank you!!!

I installed the latest service pack and I open the database!

Thank you mallier!!
And thank you harshal_in for your hints.

Fabio

Free XML ODBC Drivers?

Hi to everybody, I am a newbie who is trying to import data from and
XML file into a table in SQL Server 2000. I've reading all the MS
information about the SQLXML's 'XML Bulk Load' and it seems that this
feature can only be accesible through the 'DTS Designer' in the
Enterprise Manager.
I've tried successfully to import the XML using a DataDirect ODBC
driver. Unfortunately it's not free and its evalutation version
doesn't long too much...
So, I'd like to ask the community if somebody knows and ODBC driver
that could be used to import XML into SQL Server 2000 and that would
be free/open source.
Also, since it seems that XML Bulk Load can only be accessible through
the 'DTS Designer' I'd like to know if I'm wrong and where I can find
the info to make this useful feature work in the import/export wizard.
Greetings,
DavidI didn't think SQL XML Bulk Load had any UI at all. I thought it was just a
COM object. Well there is a COM object as I use this from VBScript daily.
This script happens to be inside an ActiveX Script Task, but that is just my
implementation.
Darren Green
http://www.sqldts.com
http://www.sqlis.com
"David Grant" <icebold54@.hotmail.com> wrote in message
news:18503386.0502280504.74c7ddf3@.posting.google.com...
> Hi to everybody, I am a newbie who is trying to import data from and
> XML file into a table in SQL Server 2000. I've reading all the MS
> information about the SQLXML's 'XML Bulk Load' and it seems that this
> feature can only be accesible through the 'DTS Designer' in the
> Enterprise Manager.
> I've tried successfully to import the XML using a DataDirect ODBC
> driver. Unfortunately it's not free and its evalutation version
> doesn't long too much...
> So, I'd like to ask the community if somebody knows and ODBC driver
> that could be used to import XML into SQL Server 2000 and that would
> be free/open source.
> Also, since it seems that XML Bulk Load can only be accessible through
> the 'DTS Designer' I'd like to know if I'm wrong and where I can find
> the info to make this useful feature work in the import/export wizard.
> Greetings,
> David|||Dear David, I'm newbie too...and I'm improving in your same problem...
Can you indicate me the DataDirect driver you have downloaded and a little
example of DTS you have developped to import the xml file?
Best regards
Bruno Stefanutti
"David Grant" wrote:

> Hi to everybody, I am a newbie who is trying to import data from and
> XML file into a table in SQL Server 2000. I've reading all the MS
> information about the SQLXML's 'XML Bulk Load' and it seems that this
> feature can only be accesible through the 'DTS Designer' in the
> Enterprise Manager.
> I've tried successfully to import the XML using a DataDirect ODBC
> driver. Unfortunately it's not free and its evalutation version
> doesn't long too much...
> So, I'd like to ask the community if somebody knows and ODBC driver
> that could be used to import XML into SQL Server 2000 and that would
> be free/open source.
> Also, since it seems that XML Bulk Load can only be accessible through
> the 'DTS Designer' I'd like to know if I'm wrong and where I can find
> the info to make this useful feature work in the import/export wizard.
> Greetings,
> David
>|||See below.
"David Grant" <icebold54@.hotmail.com> wrote in message
news:18503386.0502280504.74c7ddf3@.posting.google.com...
> Hi to everybody, I am a newbie who is trying to import data from and
> XML file into a table in SQL Server 2000. I've reading all the MS
> information about the SQLXML's 'XML Bulk Load' and it seems that this
> feature can only be accesible through the 'DTS Designer' in the
> Enterprise Manager.
This is incorrect. The SQLXML XML BulkLoad component is accessible as a COM
object.

> I've tried successfully to import the XML using a DataDirect ODBC
> driver. Unfortunately it's not free and its evalutation version
> doesn't long too much...
> So, I'd like to ask the community if somebody knows and ODBC driver
> that could be used to import XML into SQL Server 2000 and that would
> be free/open source.
SQLXML is not an ODBC driver but internally uses an OLEDB provider.

> Also, since it seems that XML Bulk Load can only be accessible through
> the 'DTS Designer' I'd like to know if I'm wrong and where I can find
> the info to make this useful feature work in the import/export wizard.
Check out http://msdn.microsoft.com/sqlxml.

> Greetings,
> David

Free XML ODBC Drivers?

Hi to everybody, I am a newbie who is trying to import data from and
XML file into a table in SQL Server 2000. I've reading all the MS
information about the SQLXML's 'XML Bulk Load' and it seems that this
feature can only be accesible through the 'DTS Designer' in the
Enterprise Manager.
I've tried successfully to import the XML using a DataDirect ODBC
driver. Unfortunately it's not free and its evalutation version
doesn't long too much...
So, I'd like to ask the community if somebody knows and ODBC driver
that could be used to import XML into SQL Server 2000 and that would
be free/open source.
Also, since it seems that XML Bulk Load can only be accessible through
the 'DTS Designer' I'd like to know if I'm wrong and where I can find
the info to make this useful feature work in the import/export wizard.
Greetings,
David
I didn't think SQL XML Bulk Load had any UI at all. I thought it was just a
COM object. Well there is a COM object as I use this from VBScript daily.
This script happens to be inside an ActiveX Script Task, but that is just my
implementation.
Darren Green
http://www.sqldts.com
http://www.sqlis.com
"David Grant" <icebold54@.hotmail.com> wrote in message
news:18503386.0502280504.74c7ddf3@.posting.google.c om...
> Hi to everybody, I am a newbie who is trying to import data from and
> XML file into a table in SQL Server 2000. I've reading all the MS
> information about the SQLXML's 'XML Bulk Load' and it seems that this
> feature can only be accesible through the 'DTS Designer' in the
> Enterprise Manager.
> I've tried successfully to import the XML using a DataDirect ODBC
> driver. Unfortunately it's not free and its evalutation version
> doesn't long too much...
> So, I'd like to ask the community if somebody knows and ODBC driver
> that could be used to import XML into SQL Server 2000 and that would
> be free/open source.
> Also, since it seems that XML Bulk Load can only be accessible through
> the 'DTS Designer' I'd like to know if I'm wrong and where I can find
> the info to make this useful feature work in the import/export wizard.
> Greetings,
> David
|||Dear David, I'm newbie too...and I'm improving in your same problem...
Can you indicate me the DataDirect driver you have downloaded and a little
example of DTS you have developped to import the xml file?
Best regards
Bruno Stefanutti
"David Grant" wrote:

> Hi to everybody, I am a newbie who is trying to import data from and
> XML file into a table in SQL Server 2000. I've reading all the MS
> information about the SQLXML's 'XML Bulk Load' and it seems that this
> feature can only be accesible through the 'DTS Designer' in the
> Enterprise Manager.
> I've tried successfully to import the XML using a DataDirect ODBC
> driver. Unfortunately it's not free and its evalutation version
> doesn't long too much...
> So, I'd like to ask the community if somebody knows and ODBC driver
> that could be used to import XML into SQL Server 2000 and that would
> be free/open source.
> Also, since it seems that XML Bulk Load can only be accessible through
> the 'DTS Designer' I'd like to know if I'm wrong and where I can find
> the info to make this useful feature work in the import/export wizard.
> Greetings,
> David
>
|||See below.
"David Grant" <icebold54@.hotmail.com> wrote in message
news:18503386.0502280504.74c7ddf3@.posting.google.c om...
> Hi to everybody, I am a newbie who is trying to import data from and
> XML file into a table in SQL Server 2000. I've reading all the MS
> information about the SQLXML's 'XML Bulk Load' and it seems that this
> feature can only be accesible through the 'DTS Designer' in the
> Enterprise Manager.
This is incorrect. The SQLXML XML BulkLoad component is accessible as a COM
object.

> I've tried successfully to import the XML using a DataDirect ODBC
> driver. Unfortunately it's not free and its evalutation version
> doesn't long too much...
> So, I'd like to ask the community if somebody knows and ODBC driver
> that could be used to import XML into SQL Server 2000 and that would
> be free/open source.
SQLXML is not an ODBC driver but internally uses an OLEDB provider.

> Also, since it seems that XML Bulk Load can only be accessible through
> the 'DTS Designer' I'd like to know if I'm wrong and where I can find
> the info to make this useful feature work in the import/export wizard.
Check out http://msdn.microsoft.com/sqlxml.

> Greetings,
> David