SQL Neue Database in SQL Server 2014 einfügen

[jonesjunior]

Hi,

ich möchte zu Testzwecken eine Database in Microsoft SQL Server Management Studio einfügen, verbunden ist LocalDB des SQL Servers 2014.

https://raw.githubusercontent.com/j...r-sakila-db/sql-server-sakila-insert-data.sql

Hinter dem Link verbergen sich die Daten, die ich einfügen möchte. Ich habe einfach eine Query geöffnet und alles reinkopiert, leider bekomme ich eine Fehlermeldung.

Msg 4902, Level 16, State 1, Line 14
Cannot find the object "staff" because it does not exist or you do not have permissions.


Wie bekomme ich die Sachen rein?

Danke im Voraus!

 

[nittels]

Hallo,

Die Tabellen müssen schon existieren bevor du diesen Script anwenden kannst. Dazu brauchst du ein Backup welches du einspielen kannst, die Datafiles, die du an die SQL Instanz einbinden kannst oder einen anderen Script der dir das DB Schema erstellt (CREATE TABLE z.B.).

Die FM sagt aus, dass der Script die Objekte nicht finden kann (in deinem Fall die Tabelle "staff").

 

[Targa]

https://github.com/jOOQ/jOOQ/tree/master/jOOQ-examples/Sakila/sql-server-sakila-db

Erst sql-server-sakila-schema.sql als Query ausführen, damit werden die Tabellen angelegt die du dann anschließend mit den Daten befüllen kannst.

(Ich denke zumindest, dass war der richtige Link)

 

[jonesjunior]

Hi,
danke euch schon mal.
Schema ausführen als Query hatte ich auch schon versucht, Fehlermeldung;

Spoiler

Msg 911, Level 16, State 1, Line 14
Database 'sakila' does not exist. Make sure that the name is entered correctly.
Msg 4902, Level 16, State 1, Line 28
Cannot find the object "actor" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 30
Cannot find the object "actor" because it does not exist or you do not have permissions.
Msg 2714, Level 16, State 6, Line 38
There is already an object named 'country' in the database.
Msg 1781, Level 16, State 1, Line 45
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 45
Could not create constraint or index. See previous errors.
Msg 2714, Level 16, State 6, Line 52
There is already an object named 'city' in the database.
Msg 1781, Level 16, State 1, Line 61
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 61
Could not create constraint or index. See previous errors.
Msg 1913, Level 16, State 1, Line 63
The operation failed because an index or statistics with name 'idx_fk_country_id' already exists on table 'city'.
Msg 2714, Level 16, State 6, Line 70
There is already an object named 'address' in the database.
Msg 1781, Level 16, State 1, Line 82
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 82
Could not create constraint or index. See previous errors.
Msg 1913, Level 16, State 1, Line 84
The operation failed because an index or statistics with name 'idx_fk_city_id' already exists on table 'address'.
Msg 2714, Level 16, State 5, Line 86
There is already an object named 'fk_address_city' in the database.
Msg 1750, Level 16, State 0, Line 86
Could not create constraint or index. See previous errors.
Msg 2714, Level 16, State 6, Line 93
There is already an object named 'language' in the database.
Msg 1781, Level 16, State 1, Line 100
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 100
Could not create constraint or index. See previous errors.
Msg 2714, Level 16, State 6, Line 107
There is already an object named 'category' in the database.
Msg 1781, Level 16, State 1, Line 114
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 114
Could not create constraint or index. See previous errors.
Msg 2714, Level 16, State 6, Line 121
There is already an object named 'customer' in the database.
Msg 1781, Level 16, State 1, Line 135
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 135
Could not create constraint or index. See previous errors.
Msg 1781, Level 16, State 1, Line 137
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 137
Could not create constraint or index. See previous errors.
Msg 1913, Level 16, State 1, Line 139
The operation failed because an index or statistics with name 'idx_fk_store_id' already exists on table 'customer'.
Msg 1913, Level 16, State 1, Line 141
The operation failed because an index or statistics with name 'idx_fk_address_id' already exists on table 'customer'.
Msg 1913, Level 16, State 1, Line 143
The operation failed because an index or statistics with name 'idx_last_name' already exists on table 'customer'.
Msg 2714, Level 16, State 6, Line 150
There is already an object named 'film' in the database.
Msg 2714, Level 16, State 5, Line 169
There is already an object named 'CHECK_special_features' in the database.
Msg 1750, Level 16, State 0, Line 169
Could not create constraint or index. See previous errors.
Msg 2714, Level 16, State 5, Line 175
There is already an object named 'CHECK_special_rating' in the database.
Msg 1750, Level 16, State 0, Line 175
Could not create constraint or index. See previous errors.
Msg 1781, Level 16, State 1, Line 177
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 177
Could not create constraint or index. See previous errors.
Msg 1913, Level 16, State 1, Line 179
The operation failed because an index or statistics with name 'idx_fk_language_id' already exists on table 'film'.
Msg 1913, Level 16, State 1, Line 181
The operation failed because an index or statistics with name 'idx_fk_original_language_id' already exists on table 'film'.
Msg 1767, Level 16, State 0, Line 189
Foreign key 'fk_film_actor_actor' references invalid table 'actor'.
Msg 1750, Level 16, State 0, Line 189
Could not create constraint or index. See previous errors.
Msg 4902, Level 16, State 1, Line 198
Cannot find the object "film_actor" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 200
Cannot find the object "film_actor" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 202
Cannot find the object "film_actor" because it does not exist or you do not have permissions.
Msg 2714, Level 16, State 6, Line 209
There is already an object named 'film_category' in the database.
Msg 1781, Level 16, State 1, Line 218
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 218
Could not create constraint or index. See previous errors.
Msg 1913, Level 16, State 1, Line 220
The operation failed because an index or statistics with name 'idx_fk_film_category_film' already exists on table 'film_category'.
Msg 1913, Level 16, State 1, Line 222
The operation failed because an index or statistics with name 'idx_fk_film_category_category' already exists on table 'film_category'.
Msg 2714, Level 16, State 6, Line 228
There is already an object named 'film_text' in the database.
Msg 1781, Level 16, State 1, Line 248
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 248
Could not create constraint or index. See previous errors.
Msg 1913, Level 16, State 1, Line 250
The operation failed because an index or statistics with name 'idx_fk_film_id' already exists on table 'inventory'.
Msg 1913, Level 16, State 1, Line 252
The operation failed because an index or statistics with name 'idx_fk_film_id_store_id' already exists on table 'inventory'.
Msg 2714, Level 16, State 6, Line 259
There is already an object named 'staff' in the database.
Msg 1781, Level 16, State 1, Line 275
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 275
Could not create constraint or index. See previous errors.
Msg 1913, Level 16, State 1, Line 277
The operation failed because an index or statistics with name 'idx_fk_store_id' already exists on table 'staff'.
Msg 1913, Level 16, State 1, Line 279
The operation failed because an index or statistics with name 'idx_fk_address_id' already exists on table 'staff'.
Msg 2714, Level 16, State 6, Line 286
There is already an object named 'store' in the database.
Msg 1781, Level 16, State 1, Line 297
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 297
Could not create constraint or index. See previous errors.
Msg 1913, Level 16, State 1, Line 299
The operation failed because an index or statistics with name 'idx_fk_address_id' already exists on table 'store'.
Msg 1913, Level 16, State 1, Line 301
The operation failed because an index or statistics with name 'idx_fk_store_address' already exists on table 'store'.
Msg 2714, Level 16, State 6, Line 309
There is already an object named 'payment' in the database.
Msg 1781, Level 16, State 1, Line 322
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 322
Could not create constraint or index. See previous errors.
Msg 1913, Level 16, State 1, Line 324
The operation failed because an index or statistics with name 'idx_fk_staff_id' already exists on table 'payment'.
Msg 1913, Level 16, State 1, Line 326
The operation failed because an index or statistics with name 'idx_fk_customer_id' already exists on table 'payment'.
Msg 2714, Level 16, State 6, Line 333
There is already an object named 'rental' in the database.
Msg 1781, Level 16, State 1, Line 347
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 347
Could not create constraint or index. See previous errors.
Msg 1913, Level 16, State 1, Line 349
The operation failed because an index or statistics with name 'idx_fk_inventory_id' already exists on table 'rental'.
Msg 1913, Level 16, State 1, Line 351
The operation failed because an index or statistics with name 'idx_fk_customer_id' already exists on table 'rental'.
Msg 1913, Level 16, State 1, Line 353
The operation failed because an index or statistics with name 'idx_fk_staff_id' already exists on table 'rental'.
Msg 1913, Level 16, State 1, Line 355
The operation failed because an index or statistics with name 'idx_uq' already exists on table 'rental'.
Msg 2714, Level 16, State 5, Line 359
There is already an object named 'fk_customer_store' in the database.
Msg 1750, Level 16, State 0, Line 359
Could not create constraint or index. See previous errors.
Msg 2714, Level 16, State 5, Line 361
There is already an object named 'fk_inventory_store' in the database.
Msg 1750, Level 16, State 0, Line 361
Could not create constraint or index. See previous errors.
Msg 2714, Level 16, State 5, Line 363
There is already an object named 'fk_staff_store' in the database.
Msg 1750, Level 16, State 0, Line 363
Could not create constraint or index. See previous errors.
Msg 2714, Level 16, State 5, Line 365
There is already an object named 'fk_payment_rental' in the database.
Msg 1750, Level 16, State 0, Line 365
Could not create constraint or index. See previous errors.
Msg 2714, Level 16, State 3, Procedure customer_list, Line 372
There is already an object named 'customer_list' in the database.
Msg 208, Level 16, State 1, Procedure film_list, Line 401
Invalid object name 'film_actor'.
Msg 2714, Level 16, State 3, Procedure staff_list, Line 409
There is already an object named 'staff_list' in the database.
Msg 2714, Level 16, State 3, Procedure sales_by_store, Line 426
There is already an object named 'sales_by_store' in the database.
Msg 2714, Level 16, State 3, Procedure sales_by_film_category, Line 453
There is already an object named 'sales_by_film_category' in the database.

 

[Targa]

Erstelll die Datenbank 'sakila' manuell und lösch dann die erste Zeile 'CREATE DATABASE sakila;' aus dem Query und führe es ernaut aus, dann klappts.

 

[jonesjunior]

Hat funktioniert, thanks