7 replies
by alterego2
I know of two methods:
1)isqlw
2)MMC
1)isqlw will allow you to run SQL commands from a command prompt or user interface.
2)MMC will allow you to connect via the management console (easier if you are a novice)
Either method will require you to upload file groups/databases.
ISPs usually only allow isqlw access and should provide full instructions on how to set this up (fairly straight forward you just choose your client netwrok protocol and a remote port to connect to). You will need the SQL client software.
The following address has a bit of information that you might find useful.
http://www.atlantis-intl.com/isp/sql7.html
by wdarylwood
by donq
by wdarylwood
by b1xml2
The answers are quite straight-forward:-
1. Unless you have at least 128kb/s in your internet connection, using MMC (SQL Enterprise Manager) to connect to your database on the ISP is simply going to time out.
2. I have ported data to MS SQL Server7.0 residing on the ISP Network. This is my advice:-
a. Have a local database and SQL 7 (a desktop version is pretty good) on the box being used to port the data. It is always a good idea to have an exact copy on your box. Never rely completely on someone else making a backup for you. Backups have been known to fail at crucial times!!!
b. Porting your entire database or a portion of it is extremely easy to do using DTS packages.
c. Connecting to the SQL Database is easy using the Query Analyser or what was known as ISQL/Windows.
d. If you are dealing with SQL 7, forget about Access. SQL 7 has much more powerful ANSI-SQL support as it is MS's flagship RDBMS.
e. Data entry can be done via the web application if so desired, or simply through sql scripts executed via the Query Analyzer or instead porting of tables with data through DTS packages.
f. And by the way, index your tables thoughtfully; use stored procedures to get the best out of SQL.
Note: whether you have the SQL Server Engine installed or not, you still should have the SQL Client Utilities Installed!
Regards,
Brandon Driesen
Senior Analyst Programmer.
by wdarylwood
by wdarylwood
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending