Member Avatar for wchitamb

I have made created a databse MSSQL and want to upload it to my web space how do i go about it.

  • 3 Contributors
  • 2 Replies
  • 101 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by william_stam

Dani AI

Generated

: the first step is to confirm what the web host actually provides for Microsoft SQL Server (instance name, version, authentication type, maximum database size, and whether remote connections or restore operations are permitted). was right to ask that question: hosts differ widely — some give a live SQL Server instance and a control panel for imports, others will only restore a file for the customer on request.

Common, practical deployment options and what they require:

  • Full backup (.bak) restore — create a full backup on the source server (SSMS Tasks → Backup), compress it, upload to the host and ask support to restore if the host does not permit customer restores. Note: a backup from a newer SQL Server cannot be restored to an older server.

  • Schema+data script or import — generate SQL scripts that contain schema and data (or export data via bcp/Import‑Export Wizard) and run them on the host’s server if remote execution is allowed.

  • Direct copy — if both source and target allow remote connections and the same version, use SSMS Copy Database / Import-Export or a migration tool to push the objects and data.

If the host does not offer MSSQL at all, a migration to MySQL or another engine is required; that usually needs schema translation and data conversion (tools exist but the process is not automatic).

Practical tips: confirm target SQL Server version before creating a backup; prefer SQL Authentication for hosted environments; disable foreign keys/constraints during large imports and re-enable afterward; compress large files before FTP upload and include a short README for host support (desired DB name, login to create, etc.). Official Microsoft references for backup/restore and scripting are useful for the exact steps: and .

Recommended Answers

All 2 Replies

Member Avatar for Zachery

Does your webspace have a MSSQL server attached locally or remotely?

Are you sure you just didn't make a SQL file? or a MySQL database dump?

Member Avatar for william_stam

create a sql dump and send it to the web space company? with a very nice letter asking very nicly for them to so it. works best.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.