Knowledge bases

Import project from existing Microsoft SQL Server

admin

Jul 17, 2021 — 2 min read

Instructions on how to make project using existing database in dynobird.com. Dynobird only support SQL generation from official SQL Server Management Studio. If you don't have SQL Server Management Studio, please install from this official SQL Server Management Studio https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

Open SQL Server Management Studio

2.a In Object explorer, click right on your database and choose Tasks in section A

2.b Choose menu Generate Scripts… in section B

3.B Click Choose Object in pop up dialog follow below picture in rectangle section A

3.B Select radio button Select specific database objects follow below picture in rectangle section B. It will show all tables in database.

3.C Select all tables in check box follow below picture in rectangle section C

3.D Click next

4.A Choose Open in new query window for show SQL create table.

5.A Click next in this summary

6 If success it will show like this. Then click finish to showing SQL Create.

7.A If all success it will show this SQL Create. Copy all script in section A. Don't change this sql format. It will broken in dynobird parsing.

8. Paste script create table to dynobird import panel

9. After success import it will show like this

Loading comment system....

Import design from existing database

Dynobird is a robust tool designed to streamline your database design process. With its ability to import designs from existing databases, you don't need to start from scratch. This guide will walk you through how to extract 'CREATE TABLE' scripts from your database GUI and import them into Dynobird. Extracting

How to Change Your Password in Dynobird

Maintaining the security of your Dynobird account is crucial. One of the best practices is to periodically change your password. Here's a step-by-step guide on how to change your password in Dynobird: Changing Your Password 1. Click on the 'File' menu located in the top menu bar. 2. From the

Creating an Organization in Dynobird

Dynobird provides an efficient workspace for managing your team - the 'Organization'. By creating an organization, you can easily collaborate with your team members. Follow these steps to create a new organization: Creating an Organization 1. Open the 'File' menu located in the top menu bar. 2. Click 'Explore'. You

How to Change Table Header Colors

Customizing the look of your tables in Dynobird can significantly improve your database design process. One such customization option is changing the color of table headers. There are two methods to achieve this: using the color palette in the Home menu for bulk changes, or using the color palette in

Import project from existing Microsoft SQL Server

admin

Read more

Import design from existing database

How to Change Your Password in Dynobird

Creating an Organization in Dynobird

How to Change Table Header Colors

Company

Usefull Links

Newsletter