This is the same username and password you chose when you created your database.
Authentication: Select Use SQL Server Authentication and enter your database username and password.This information is shown within your Fasthosts control panel. Server name: Enter the IP address of your MSSQL database.Destination: Select SQL Server Native Client 11.0 from the drop down menu.Step 5ĭefine the formatting of your data source. You can use this window to experiment with the formatting. When the table looks correct, click Next.Įnter the details of your MSSQL database, as follows: You can select your specific extension if it is available.
If you are using an alternate file extension you can select it from the drop down in the bottom right of the file explorer. sql file on our computer, however if you would like to import content from a separate database, select SQL Server Native Client 11.0 from the drop down menu and enter the connection details for this database in the text boxes provided and skip to step 6. In this example we are importing data from a. Step 4Ĭhoose a data source for the data you want to import from the drop down. The SQL Server Import and Export Wizard will open. Right-click on your database and select Tasks then Import Data from the menu. Open SQL Server Management Studio and connect to your database.
0 kommentar(er)
