Thanks but the problem is the sql 7.0 DB is protected from the web,
behind a firewall!
I was thinking the only method would be a csv file, that I could run a
sscript on server-side or even to give to the admin staff to import. But
I thought the might be a better way:-)
Regards,
Andrew Scott
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 25 September 2001 21:33 PM
To: SQL
Subject: Re: SQL 2000 - SQL 7.0
I haven't tested this to be sure, but there are only minimal differences
between SQL Server 7.0 and SQL Server 2000. Unless the database you
built
on SQL Server 2000 is making use of advanced 2000-only features (such as
the CASCADE keyword instead of a separate trigger), you should have no
problems transferring the database through DTS.
Worst-case scenario is that you have to export the SQL scripts to create
the database and then write a few lines of SELECT ... INTO or INSERT ...
SELECT statements.
To be absolutely sure, open your SQL Server 2000 Books Online and check
out
the "What's New" topic in the Contents tab. It will tell you all the
things that won't work in SQL Server 7.0.
|---------------------------+-------------------------------------------
--|
|Eric A. Laney |The world is a stage, but the play is badly
|
|Systems Engineer |cast.
|
|LAN Optimization Team |
|
|Verizon Data Services |
|
|Voice: 813.978.4404 |
|
|Pager: 888.985.8519 |
|
|---------------------------+-------------------------------------------
--|
"Andrew
Scott" To: SQL
<[EMAIL PROTECTED]>
<andrewcs@tig cc:
.com.au> Subject: SQL 2000 - SQL 7.0
2001-09-25
02:18
Please
respond to
sql
I am in a bit of a spot, my host only supports sql 7.0 and I no longer
have this. Is it possible to get the information across to the other the
destination (sql 7.0) is also behind a firewall so I have to back the
data up and send it over to them where they then restore the DB.
Advice Please, I need to know if I can export to an older DB as
described above.
Regards,
Andrew Scott
-----Original Message-----
From: stas [mailto:[EMAIL PROTECTED]]
Sent: Saturday, 22 September 2001 2:10 AM
To: SQL
Subject: Connecting with EM
Hello,
I have a server that is sitting on the DMZ side of my firewall that I am
trying to connect to with Enterprise Manager from the LAN side of the
Firewall. I fail to register the server with EM.
I don't have any problems connecting to other remote SQL servers on the
net,
so I think it has something to do with port blocking happening on the
DMZ.
I opened up TCP/IP port 1433 but still no luck.
Can somebody please offer any advice?
Thanks much
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
